From: Paul DuBois Date: March 22 1999 7:21pm Subject: Re: case sensitive and BLOBS List-Archive: http://lists.mysql.com/mysql/788 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" At 12:57 PM -0600 3/22/1999, efrazier@stripped wrote: >Hi, > >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/