Hi!

I'm trying to SELECT rows from my database in which a user's query matches a keyword within the column 'kwords.'

The keywords in the kwords column are seperated by commas (no spaces) in a text string.

I tried the following:

SELECT * FROM table WHERE 'news' IN(keywords)

but this returned no rows.

I've only seen the IN() operator used the other way around ((where keyword IN('news'), for example), but this of course wouldn't work in my situation.

Any ideas on how to accomplish what I'm trying to do?

(MySQL version 4.1.9)

    Write a Reply...