> 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.
You can do it in this way:
"SELECT * FROM table WHERE LOWER(field) LIKE '%".strtolower($variable)."%'"
LOWER is an SQL function and strtolower is a PHP function. They are both
doing the same thing: returning string with all alphabetic characters
converted to lowercase.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php