At 12:57 PM -0600 3/22/1999, efrazier@stripped wrote:
>I wrote a while ago about how to do a case insensitive search on a text
>field and got back they way of doing it with LIKE '%searchterm%' which works
>great, but I am finding that when doing this on a LONGBLOB field it does not
>do a case IN sensitive search. Is this something weird about long blobs or
>am I just messing something up?
>select * from pinklisting WHERE _desc LIKE '%guild%';
That's how BLOB columns work. You might want to use ALTER TABLE
to convert your column to LONGTEXT instead.
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/