Re: mysql statement [SOLVED]

Got if figured out, needed a sub-select type of query: mysql> SELECT * -> FROM ( SELECT * FROM orders -> WHERE group = "groupname" ) -> AS orders UNION SELECT * FROM orders -> WHERE ordernum LIKE "35132" -> OR price LIKE "35132" -> OR partnum LIKE "35132" -> OR vendor LIKE "35132" -> OR purpose LIKE "35132" -> OR tracking LIKE "35132" -> OR contact LIKE "35132" -> AND group LIKE 'mac' -> ORDER BY ordernum -> LIMIT 0 , 30; Jas wrote: > I am looking for some advice on how to achieve something and so far have > been unable to do what I am looking to do. > > Here is the query I am using: > mysql> SELECT * > -> FROM orders > -> WHERE ordernum LIKE "35132" > -> OR price LIKE "35132" > -> OR partnum LIKE "35132" > -> OR vendor LIKE "35132" > -> OR purpose LIKE "35132" > -> OR tracking LIKE "35132" > -> OR contact LIKE "35132" > -> AND group LIKE 'mac' > -> ORDER BY ordernum > -> LIMIT 0 , 30; > > First here is the table structure: > mysql> describe orders; > +-------------+--------------+------+-----+---------+----------------+ > | Field | Type | Null | Key | Default | Extra | > +-------------+--------------+------+-----+---------+----------------+ > | id | int(255) | NO | PRI | | auto_increment | > | ordernum | int(10) | NO | | | | > | date | varchar(60) | NO | | | | > | time | varchar(20) | NO | | | | > | group | varchar(20) | NO | | | | > | quantity | int(10) | NO | | | | > | description | varchar(255) | NO | | | | > | price | decimal(3,0) | NO | | | | > | partnum | varchar(40) | NO | | | | > | vendor | varchar(65) | NO | | | | > | purpose | varchar(255) | NO | | | | > | tracking | varchar(120) | NO | | | | > | contact | varchar(255) | NO | | | | > | eta | varchar(50) | NO | | | | > | department | varchar(125) | NO | | | | > | notes | varchar(255) | NO | | | | > +-------------+--------------+------+-----+---------+----------------+ > 16 rows in set (0.00 sec) > > I am trying to essentially LIMIT all records returned to be limited by > the group field so I can search for records and limit the rows > returned by that one field. > > Any tips? TIA. > jas