Another SQL question
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
>>> 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:
> 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