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
-----------------------------------------------------------------------------
