Why not:
SELECT * FROM myTable WHERE myColumn IN ('this','that',.....)
It's standard SQL (I'm pretty sure - I've been using that form for 10+
years with Postgres.
Len Morgan
Bob Sneidar wrote:
<div class="moz-text-flowed">Hi all.
I am trying to find a way to query a table whose column is in a list
of values. There is nothing in any SQL book or manual that says how to
do this. It looks like they want you to build a complex SQL statement
like:
SELECT * FROM myTable WHERE myColumn = 'this' OR myColumn = 'that' or
mycolumn...
That would work for a few items but what about for a HUGE list of
several hundred items? I know Revolution has the syntax "is in" or
"contains". Does SQL have a similar function?
I tried "LIKE" as in:
SELECT * FROM myTable WHERE myColumn LIKE 'this,that,the other thing'
That returns empty cursors even though those values are in the table
plain as day.
Bob Sneidar
IT Manager
Logos Management
Calvary Chapel CM
</div>
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
