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
Regards
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 (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
