I"m trying to create a mysql statement in which includes everything on tableA that has the work 'hi' in it and but exclude everything in tableB that has 'die' in it and also from tableC that has 'fry' in it. This is what i have now
"SELECT * FROM this_table WHERE file_description LIKE '%hi%' AND file_location NOT LIKE '/die/%' AND file_location NOT LIKE '/fry/%' AND file_location NOT LIKE '/cry/%' AND file_location NOT LIKE '/shy/%' AND active <> 0 AND domain >= 0 AND archive = 0 ORDER BY file_name";
Hope you trying to see what i'm doing.
"SELECT * FROM this_table WHERE file_description LIKE '%hi%' AND file_location NOT LIKE '/die/%' AND file_location NOT LIKE '/fry/%' AND file_location NOT LIKE '/cry/%' AND file_location NOT LIKE '/shy/%' AND active <> 0 AND domain >= 0 AND archive = 0 ORDER BY file_name";
Hope you trying to see what i'm doing.