--- Gordon Stewart wrote: > WHERE `field` = 'words' > > Hi, I know how to do mysql queries where the "words" DOES appear in > the field "field"... > > However, is there a way to do a MYSQL query to EXCLUDE anything ??
You can use the NOT predicate: WHERE NOT field = 'words' or use the not-equal comparison: WHERE field <> 'words' > Is this possible ? > > Im looking on Google & see lots of examples where you want to search > for something - But not where you do not want something... This is standard SQL. You should look into MySQL's SQL reference. -- Milan Babuskov http://www.guacosoft.com
