Another SQL question

stephen barncard stephenREVOLUTION2 at barncard.com
Mon Feb 2 12:54:07 CST 2009


Ha. That's right. It's in the MySQL online manual, buried in "11.2.3.
Comparison Functions and Operators":

IN()	Check whether a value is within a set of values

2009/2/2 Bob Sneidar <bobs at twft.com>
>
> 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
>
>
> _______________________________________________
> 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



--
Stephen Barncard
-------------------------
San Francisco



More information about the use-livecode mailing list