How to remove values ​​of one column from another?

Question

MySQL

There are two tables. It is necessary to remove rows from one table that contain values ​​from a column of another table.
Those. two columns from two tables are compared, if the cell value is present in another table, then the row with this matched value is deleted from the first one.
How can you do?

Answer 1

delete from foo where fieldname in (select filedname2 from bar)