is LIKE operator case sensitive ???
| From: | Smita Manohar | Date: | Tue, 20 Aug 2002 06:27:29 +0000 |
| Subject: | is LIKE operator case sensitive ??? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-21241@lists.php.net to get a copy of this message | ||
im using query "SELECT * FROM table WHERE field LIKE '% $variable %' "
with this, i want it should not be case sensitive, and should not distinguish betn ram,Ram,RAM. but its not doing so. i don't want the case sensitive result.
what can i do to overcome this ? pls suggest any other possible way.
thnx and regds,
smita.
_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com