Hi there, you might want to take a look at the eregi function for
case-insensitive pattern matching.
"Mike De Libero" <[EMAIL PROTECTED]> wrote in message
I was wondering what the best way would be for me to do a search. The
users have 2 options for tables and either can do keyword or exact matching.
Right now I'm using REGEXP to do the work of the searching, only problem is
that it is case sensitive. We are currently running MySQL 2.23.32 and have
php 4 installed. I'm using the search with 5 different fields/columns in
one table and 2 fields/columsn in another. Thanks for you help.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php