MySQL Update Query using a left join - Stack Overflow

SELECT * FROM file_manager_folders as a LEFT JOIN file_manager_folders as b on a.id = b.id WHERE b.id IS NOT NULL and a.id IN("1","2" ...

stackoverflow.com