| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jay Blanchard | Date: | February 17 2010 6:40pm |
| Subject: | RE: compare column value to anything in a list of values | ||
| View as plain text | |||
[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.
| Thread | ||
|---|---|---|
| • compare column value to anything in a list of values | Bryan Cantwell | 17 Feb |
| • RE: compare column value to anything in a list of values | Bryan Cantwell | 17 Feb |
| • Re: compare column value to anything in a list of values | Wm Mussatto | 17 Feb |
| • RE: compare column value to anything in a list of values | Jay Blanchard | 17 Feb |
| • Re: compare column value to anything in a list of values | Baron Schwartz | 19 Feb |
