MySQL How could I delete many times a row where the values are the same

Question

I tried DELETE FROM TABLE WHERE VALUE = 10
and it works but it only delete one row but I want to delete all of the row where value is 10

Answer 1

Really strange.... "DELETE FROM table_name WHERE value=10" would do it

Answer 2

Just by memory: DELETE * FROM TABLE WHERE VALUE = 10. So add *

Answer 3

I tried it but it gives me a syntax error