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 <[email protected]>
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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
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
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
