So that text that you want to exclude....is it in a specific field? Can't tell where it would be merely by looking at your query there

Several options here. You could use UNIONS and remove each record w/ that text from each of the queries in the different UNIONS.ie. select * from ts_admin.editorial where <field> <> 'reissue'union select * from ts_admin.editorial where <field> <> 'scholastic'union select * from ts_admin.editorial where <field> <> 'media tie-in'union select * from ts_admin.editorial where <field> <> 'movie tie-in'

Thank you very much for your help, and for bearing with my newbie mistakes. And yes, the text would be in either the MISC or TITLE field. Sorry for the confusion.

QUOTE (dvsoukup @ Jan 30 2012, 04:57 PM)

So that text that you want to exclude....is it in a specific field? Can't tell where it would be merely by looking at your query there

Several options here. You could use UNIONS and remove each record w/ that text from each of the queries in the different UNIONS.ie. select * from ts_admin.editorial where <field> <> 'reissue'union select * from ts_admin.editorial where <field> <> 'scholastic'union select * from ts_admin.editorial where <field> <> 'media tie-in'union select * from ts_admin.editorial where <field> <> 'movie tie-in'