SQL and searching question

Robert0380 · 08-16-2002, 10:25 PM

lets say i have a field in a database called comments that is anything from NULL to a paragraph. I would assume a CLOB or BLOB would be in order as far as a dataype. My question is how do i perform a query that will search for part of something in a BLOB or CLOB or even a CHAR(20) ?

basically how do i return the entire entry below when im searching based on the word 'Robert':

<begin data>

If I were anyone in the world I would be Robert.

</end data>

BTW, incase its database dependant, the database im using is MySQL

gdrobson · 08-17-2002, 04:51 PM

http://www.mysql.com/doc/en/Pattern_matching.html

gdrobson · 08-17-2002, 04:53 PM

oops, i was also going to say you would want i believe anyway a query that looked like:

mysql> SELECT <column> FROM <table> WHERE <column> LIKE "%Robert%";

Robert0380 · 08-18-2002, 11:34 PM

oh sweet, i looked at the page, mysql uses REGEX's too!!
now i can use all taht regex stuff i learned in my last CS class