Grant/Revoke sql question

[Raymond Owens]

How do I use Mysql access priviledge capabilities to restrict a user to only be able to query rows in a table that contain fields which meet certain matching criteria. For instance, say the table contains engineering, marketing, and production information, a production user who logged in would only be able to query those rows which (because of the values in certain columns) relate to production. The matching criteria on which the decision is made for access priviledge would also have to be flexible allowing use of regular expressions, because the field information in a given row used to separate the engineering, marketing and production groups is distinct but not invariable. Thanks.