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
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...
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
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.
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,
5 matches
Mail list logo