Re: Seaching Keywords column

2001-03-10 Thread Alec Cawley
In message <[EMAIL PROTECTED]>, "MikeBlezien" <[EMAIL PROTECTED]> writes >Hello All, > >We have a table where keywords will be entered into a column (searchwords), up >to 3 unique keywords. Then this column will be used in a keywords >search tied to >a Category(a Category has to be selected). Th

Re: Seaching Keywords column

2001-03-10 Thread MikeBlezien
On Sat, 10 Mar 2001 14:24:18 -0500, "Tac/Smokescreen Action Network" <[EMAIL PROTECTED]> wrote: Would you happen to have an example?? I did look at the FULL TEXT search, but I'm not sure this would work in our situation,... but we maybe able to adapt to it. TIA, >>Of course, the other way to

Re: Seaching Keywords column

2001-03-10 Thread Tac/Smokescreen Action Network
MySQL 3.23 has full-text search built-in, and it's made for exactly this situation. You'll need to create a index of type FULLTEXT: http://www.mysql.com/doc/M/y/MySQL_full-text_search.html Of course, the other way to do this is to create another table with the keysword in it, and a pointer back