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... AG
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 SQL
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. Bu
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 entere
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
5 matches
Mail list logo