基于PHP中的列数据从MYSQL表中删除多行

Question

I have a table called user_favs like this :

 id | user_id | post_id
 ----------------------
 50 | 291     | 1027
 51 | 10      | 180
 52 | 771     | 1027
 53 | 92      | 133
 54 | 523     | 1027

How would I set up a database query in php to delete all rows that contain post_id 1027?

I know how to do it for single entries :

DELETE FROM user_favs WHERE post_id = 1027

But I don't know how to delete all rows that contain post_id 1027.

Is it something like :

DELETE * FROM user_favs WHERE post_id = 1027

I don't want to try it without knowing in case I mash the whole thing up ;)

Answer 1

this:

DELETE FROM user_favs WHERE post_id = 1027

will actually not delete only one row. it will delete all rows that matches the criteria post_id=1027