MySQL IF ELSE in Query

[Ryder]

MYSQL:

I have receiver _removed column and a column receiver _removed

If both are 1 then there is a DELETE query executed. Otherwise, an UPDATE query is executed.

I would just not be looking to php or both on 1 or not, I want mysql to arrange this. So this is about what it should be:

IIF (receiver_removed = 1 & & sender_removed= 1) THEN DELETE FROM table ELSEIFF (* and here the update query *)

Who can help me to make a valid mysql query them?

[opaper]

I can say 1 thing: you can with (my) SQL (as far as I know) are not both an UPDATE and DELETE query do, though you use only 1 of 2 by a check, go to your PHP therefore need .

[Zecho]

This can happen. With SQL you can write triggers. You can write a trigger on the SQL DELETE statement to delete each one also update under certain conditions.

However, not all DBMS systems rather advanced feature of SQL you will need to search or MYSQL supports it.

[MindSpace]

Triggers are available from MySQL 5.

You could use a stored procedure or stored function.

You can simply delete a run and if affected rows == 0 an update. (Or vice versa)