Hi Keith,

you can use:
pla.type IN ('1','2','3','4');

/Johan
Keith wrote:

is there any alternative to using OR for selecting between values?

ie: pla.type='1' OR pla.type='2' OR pla.type='3' OR pla.type='4'

Cheers,
Keith


--
Johan Höök, Pythagoras Engineering Group
                - MailTo:[EMAIL PROTECTED]
                - http://www.pythagoras.se
Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden
Phone: +46 8 760 00 10 Fax: +46 8 761 22 77



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



Reply via email to