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]