MYSQL IF EXISTS help

[DanielHardy]

Hi all,

 

I have the following mysql delete query that essentially deletes a row from two seperate tables "messages" and "messages2" where the id is equal to that in both of the tables. The problem I am getting (for obvious reasons) is that it will only delete from the table, if it indeed exists in both tables.

 

Here is the query:

 

DELETE FROM messages,messages2 USING messages,messages2 WHERE messages.id = messages2.id AND messages.id = ?;

 

How would I go about setting it so that the query always deletes from table "messages" and only deletes from "messages2" when a corresponding id exists?

 

I think it would involve an IF EXISTS clause, but I am not sure on this, or indeed how to implement it.

 

Thanks in advance guys

 

Dan

[DanielHardy]

Perhaps I can use an "AND, OR" somewhere?

 

Ideas please guys