List:General Discussion« Previous MessageNext Message »
From:tony Date:March 22 1999 8:10pm
Subject:Re: case sensitive and BLOBS
View as plain text  
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 Bowden | tony@stripped     
  Black Star |    The UK's Biggest Video & DVD store * Free Postage Worldwide
case sensitive and BLOBSefrazier22 Mar
  • Re: case sensitive and BLOBStony22 Mar
  • Re: case sensitive and BLOBSPaul DuBois22 Mar
Re: case sensitive and BLOBSFred Lindberg22 Mar