note 15844 deleted from function.sql-regcase by jimw
| From: | jimw@php.net | Date: | Fri, 02 Nov 2001 02:15:45 +0000 |
| Subject: | note 15844 deleted from function.sql-regcase by jimw | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-20262@lists.php.net to get a copy of this message | ||
Better solution would be to convert the SQL column to all upper-case or lower case while inserting
the data, once that's done, you can compare simply by saying:
where field_name LIKE upper('%pattern%')
As someone noted, this solution will keep the index intact because the upper function is performed
on the variable rather then the SQL Column..