[snip]
IN('value1','value2') should work for exact matches, also works for
integer values.
[/snip]IN will not open and read his CSV file... [snip] Is there a simple function or method to compare a value in a column to one or more items in a comma separated list? [/snip] In order to do this you are going to use a programming language or scripting language. For PHP you could put the values from the CSV list in an array and the use IN to compare against that array. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
