Another SQL question

Len Morgan len-morgan at crcom.net
Sat Jan 31 09:22:34 EST 2009


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>
>



More information about the Use-livecode mailing list