note 43365 added to function.strtolower

From: 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

« previous php.notes (#71301) next »