Another SQL question

Bob Sneidar 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  
for MySQL.

Bob Sneidar
IT Manager
Logos Management
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  
>> 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
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution





More information about the Use-livecode mailing list