View Single Post
  #13 (permalink)  
Old 08-24-2007, 04:43 PM
hewgriff hewgriff is offline
WebProWorld New Member
 

Join Date: Nov 2005
Posts: 1
hewgriff RepRank 0
Default Re: MySQL Multiple Select Question

select * from table1 where eid in ('100','101','102');

Would get you all the info from 100, 101 and 102 (and however many others you named specifically)

or

select * from table1 where eid like '10%';

Would get you all the info from 10, 100-109 and 1000 - 1099

Matt G.
Power tools, air tools, cordless power tools - ToolBarn.com
Reply With Quote