hello, help generate a SQL query,

UPDATE news SET display = 0 WHERE display IN (3,4) as well as UPDATE events SET display = 0 WHERE table_id = 1 AND event_id = remote news.id

    1 answer 1

    Well, so will you:

    UPDATE news, events SET news.display = 0, events.display = 0 WHERE news.display IN (3,4) AND events.table_id = 1 AND events.event_id = удаленный news.id;