sql - Update same table with IF ELSE Condition in MySQL - Stack ...

update pm_users set user_status = if ( (select u.user_status from pm_users u where u.user_id = 3 ) ...

stackoverflow.com