Re: WHERE col_name IN(....)

[Roland Bouman]

use FIND_IN_SET (http://dev.mysql.com/doc/refman/5.0/en/string-functions.html)

if you want to send in the list as a string:

SELECT * FROM keywords
WHERE find_in_set(keyword_txt,keyword_list);

however, if you've got all the words in a separated for to begin with, you'd better use that:


SELECT * FROM keywords
WHERE keyword_txt IN ('Hello','World');

Of course, the list must be specified when you create a procedure, so I´d probably generate the statement on the fly in the php script (if i was calling it from php).

ALthough it is true that one can use native dynamic sql (as opposed to generating the statemen on the client sid) using the PREPARE syntax (http://dev.mysql.com/doc/refman/5.0/en/sqlps.html), this does not do you much good, because you still need to be able to pass a variable length list (an arry or so) to the procedure (wich is presently not possible)