Re: keyword searching
| From: | CPT John W. Holmes | Date: | Wed, 12 Nov 2003 19:06:49 +0000 |
| Subject: | Re: keyword searching | ||
| References: | 1 2 3 4 5 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-31550@lists.php.net to get a copy of this message | ||
From: "Adam Williams" <awilliam@mdah.state.ms.us>
> This is my SQL query:
>
> "SELECT seriesno, governor, descr, boxno, year, eyear, docno
> from rg2 WHERE seriesno = '$_POST[seriesno]' and governor matches
> '*$searchterm*' or descr matches '*$searchterm*'";
Looks like you're doing the equivilent to a MySQL "LIKE" search, i.e.
looking for a pattern in a string instead of doing a FULLTEXT search.
Consult you're documentation, as I don't think the PHP list can be much more
help.
---John Holmes...