Re: keyword search syntax
| From: | Robb Kerr | Date: | Tue, 28 Oct 2003 02:12:11 +0000 |
| Subject: | Re: keyword search syntax | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-167825@lists.php.net to get a copy of this message | ||
On Tue, 28 Oct 2003 02:09:06 +0000, David Otton wrote:
>
> Personally, I'd normalize that into a keyword table, a record table and a
> joining table.
>
> However, the SQL keyword you're looking for is LIKE
>
> WHERE field LIKE '%$variable%'
I agree. I'd structure the data quite differently. But, I've got the data
from a client and at this point I don't have the authority to restructure
the database. Thanx for the tip on the LIKE command.
Robb