Re: [PHP] keyword search syntax

2003-10-28 Thread Raditha Dissanayake
If you put up a full text index on it you can do searches that smell like a primitive search engine. best regards Robb Kerr wrote: On Tue, 28 Oct 2003 02:09:06 +, David Otton wrote: Personally, I'd normalize that into a keyword table, a record table and a joining table. However, the

Re: [PHP] keyword search syntax

2003-10-28 Thread Robb Kerr
On Tue, 28 Oct 2003 19:37:10 +0600, Raditha Dissanayake wrote: If you put up a full text index on it you can do searches that smell like a primitive search engine. best regards Thanx. The LIKE operator wouldn't work. But, your tip on creating a FULLTEXT index and executing a MATCH...

[PHP] keyword search syntax

2003-10-27 Thread Robb Kerr
I've got a field in my database that contains keywords about the particular record. I've got a form with a text entry field for visitors to enter keywords for which they would like to find records whose keyword field contains the words they entered. The submission form assigns the keywords entered

Re: [PHP] keyword search syntax

2003-10-27 Thread David Otton
On Mon, 27 Oct 2003 20:00:24 -0600, you wrote: I've got a field in my database that contains keywords about the particular record. I've got a form with a text entry field for visitors to enter keywords for which they would like to find records whose keyword field contains the words they entered.

Re: [PHP] keyword search syntax

2003-10-27 Thread Robb Kerr
On Tue, 28 Oct 2003 02:09:06 +, 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,