Check to see if you have the Binary option on the field. That would make searches case sensitive. If it is a binary field, you need to drop the binary option.

On Aug 24, 2005, at 4: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


Chris Payne

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.15/80 - Release Date: 8/23/2005

Brent Baisley
Systems Architect
Landover Associates, Inc.
Search & Advisory Services for Advanced Technology Environments
p: 212.759.6400/800.759.0577

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to