In fact, by issuing the following query: SELECT "TEST" LIKE "test"; you can prove this to yourself, if it's case insensitive, it will return true (1), otherwise false (0). -Micah On Wednesday 24 August 2005 1:53 pm, Chris Payne wrote: > Hi there everyone, > > > > I have a little problem, I have a search where people can search the > address of a property BUT the search is case sensitive, I don’t WANT it to > be. I’m using MySQL and PHP and I generally use something like WHERE > address LIKE ‘%$stringinput%’ which works with the numbers ONLY, but when I > add the address if I don’t put a capital infront of each part of the > address it won’t show up. Any ideas how I can make it case INSENSITIVE? > (Think that’s the correct phrase). > > > > Any help would really be appreciated. > > > > Thanks everyone > > > > Regards > > > > Chris Payne -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
