Re: Simple Search Function
| From: | Lerp | Date: | Wed, 06 Feb 2002 19:26:07 +0000 |
| Subject: | Re: Simple Search Function | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16572@lists.php.net to get a copy of this message | ||
Hi there, you might want to take a look at the eregi function for
case-insensitive pattern matching.
Joe :)
"Mike De Libero" <mikede@soreye.com> wrote in message
news:001f01c1af1c$4d7dce00$6901a8c0@slugo...
Hi guys,
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.
TIA,
Mike