Re: OR in MySQL statement?

[Gabriel Ricard]

You can do it exactly like that, or you could use the IN() syntax if 
you have a large number of values to check.

SELECT * FROM list WHERE name IN('$this1', '$this2', '$this3')

- Gabriel

On Wednesday, October 15, 2003, at 04:16  PM, Mike At Spy wrote:



How could I write a statement that uses something like 'OR' as a case. 
 Like
this:

SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name =
'$that1'
?

Thanks for any help,

-Mike



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]