> does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3')
as
> used in oracle.
MySQL supports this syntax exactly. See
http://www.mysql.com/doc/en/Comparison_Operators.html (halfway the page)
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.
Hello joe,
Monday, April 5, 2004, 3:17:27 PM, you wrote:
jc> does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as
jc> used in oracle.
Yes.
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html
--
MySQL General Mailing List
For list archives: htt
does MySQL have an equilivent for the WHERE Unique_id IN ('1',' 2', '3') as
used in oracle.
select *
from tableX
where tableX_id IN ('1', '2', '3')
i.e. if I have a comma delimited list of values for a certain field on a
table...I can search for all records that have the values in my comma
delim
