Another SQL question

Bob Sneidar bobs at twft.com
Mon Feb 2 16:46:37 EST 2009


Wow! Not in my reference manual it's not. 11.2 is "Numeric Types". But  
then I downloaded the PDF manual. Seems that it is either out of date  
or not "exactly" correct. I also searched for IN() in the manual and  
came up with squadouch.

Bob Sneidar
IT Manager
Logos Management
Calvary Chapel CM

On Feb 2, 2009, at 10:54 AM, stephen barncard wrote:

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