Re: Case sensitive

better to use the sql UPPER/LOWER and keep your variable values the same Bastien

From: <tg-php@gryffyndevelopment.com> To: <php-db@lists.php.net> CC: <chris@artistwd.com> Subject: Re: [PHP-DB] Case sensitive Date: Wed, 24 Aug 2005 14:29:56 -0400 One trick is to force the case in your comparison: $ucstringinput = strtoupper($stringinput); $qry = "select * from sometable where upper(address) like '%$ucstringinput%'" Didn't think LIKE was case sensitive, but regardless... forcing upper or lowercase in your comparison doesn't affect output but will make your case sensitivity issue moot. HTH -TG = = = Original 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 ___________________________________________________________ Sent by ePrompter, the premier email notification software. Free download at http://www.ePrompter.com. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php