Case sensitive
| From: | Chris Payne | Date: | Wed, 24 Aug 2005 20:53:55 +0000 |
| Subject: | Case sensitive | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-40127@lists.php.net to get a copy of this message | ||
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