WHERE col_name IN(....)

[Michael Dunn]

This may not be possible, or possible using a different method, however, I'd like to send in a comma separated list of possible values, for instance i've got a keyword table, my customer searches for something like 'Hello World' I'd like to be able to make the statement WHERE keyword IN('Hello', 'World'). Obviously from PHP this is easy if i create the entire statement. Howerver is it possible to send in Hello and World a preset list and end up with some like

CREATE PROCEDURE `keywordsearch`(keyword_list VARCHAR(150))
BEGIN
SELECT * FROM keywords
WHERE keyword_txt IN(keyword_list);
END

then send it a list like "'hello','world'".

Now i should say that the above is leagal, and will work if I send it "hello" by it self, or "world" by it self, but then flunks when I send it the two together. I'm sure because it's treating it as an entire string.