Another SQL question
bobs at twft.com
Mon Feb 2 12:53:09 EST 2009
I will definitely give that a try. The odd thing is, the MySQL 5
reference manual makes absolutely NO mention of the IN clause. It
would be AWESOME to have in my hot little hand a comprehensive syntax
Calvary Chapel CM
On Jan 31, 2009, at 6:22 AM, Len Morgan wrote:
> 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
>> do this. It looks like they want you to build a complex SQL statement
>> SELECT * FROM myTable WHERE myColumn = 'this' OR myColumn = 'that' or
>> 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
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
More information about the Use-livecode