note 43365 added to function.strtolower
| From: | unordainedatpseudotheosdotcom at rn2 dot php dot net | Date: | Fri, 18 Jun 2004 22:33:06 +0000 |
| Subject: | note 43365 added to function.strtolower | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-71301@lists.php.net to get a copy of this message | ||
[adding to zaid's] For databases where LIKE queries are not case-insensitive (firebird, for
example), do
$field_value = strtoupper($field_value);
WHERE ... UPPER($field_name) LIKE '%$field_value%' ...
it won't use an index (unless you omit the first %), but you don't have to use lots of OR
statements together, and still risk missing something.
----
Manual Page -- http://www.php.net/manual/en/function.strtolower.php
Edit -- http://master.php.net/manage/user-notes.php?action=edit+43365
Delete -- http://master.php.net/manage/user-notes.php?action=delete+43365&report=yes
Reject -- http://master.php.net/manage/user-notes.php?action=reject+43365&report=yes
Search -- http://master.php.net/manage/user-notes.php