mysql statement

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