Help on mysql statement

[Anon]

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.

[Anon]

Grab the mysql manual, and read the section about JOIN statements.

[Anon]

Um, i read the join statement and i'm not exactly sure how to use it in my situation. In fact i don't see how it could be use.

[Anon]

Your statement only lists 1 table. You statement should look something like this:

SELECT a.*
FROM table1 a, table2 b, table3 c
WHERE a.file_description LIKE '%hi%'
AND b.file_location NOT LIKE '/die/%'
AND c.file_location NOT LIKE '/fry/%'
AND c.file_location NOT LIKE '/cry/%'
AND c.file_location NOT LIKE '/shy/%'
AND a.active <> 0
AND a.domain >= 0
and a.archive = 0
ORDER BY file_name

Ofcours you will need some way to join your tables together that works for what you want. Either an outer or inner join depending on what you want. The MySQL manual should explain what join type to use.

If this doesn't make sense to you email me with more detailed information and I'll get you a better statement.