From: tony
Date: March 22 1999 8:10pm
Subject: Re: case sensitive and BLOBS
List-Archive: http://lists.mysql.com/mysql/787
Message-Id: <19990322201018.24411.qmail@crux.blackstar.co.uk>

efrazier@stripped writes:
>select * from pinklisting WHERE _desc LIKE  '%guild%';

This doesn't work on blobs.

You want:
  SELECT * FROM pinklisting WHERE LCASE(_desc) LIKE '%guild%'

(where you have translated the text you're looking for to lower case
  beforehand of course!)

Tony
-- 
-----------------------------------------------------------------------------
 Tony Bowden | tony@stripped               http://www.blackstar.co.uk/
  Black Star |    The UK's Biggest Video & DVD store * Free Postage Worldwide
-----------------------------------------------------------------------------