note 25143 modified in function.strtolower by zak
| From: | zak@php.net | Date: | Thu, 12 Sep 2002 01:08:40 +0000 |
| Subject: | note 25143 modified in function.strtolower by zak | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-36558@lists.php.net to get a copy of this message | ||
In addition to the post by zaid@designerz.com:
There is no need to do all those upper-/lowercase conversions prior to a mysql query, since LIKE is
case-insensitive unless you define the operand to be BINARY.
Editor's Note: ...unless the field was declared BINARY in the CREATE TABLE statement :)
--zak@php.net
--was--
In addition to the post by zaid@designerz.com:
There is no need to do all those upper-/lowercase conversions prior to a mysql query, since LIKE is
case-insensitive unless you define the operand to be BINARY.
http://www.php.net/manual/en/function.strtolower.php