mysql中的两个WHERE条件删除查询

I've got a query that deletes a row from a MySQL table that works perfectly fine if the query is as follows:

$sql = "DELETE FROM table WHERE id = 1"

But it doesn't work, or give an error, when I add a AND clause:

$sql = "DELETE FROM table WHERE id = 1 AND name='Jack'"

Doesn't MySQL DELETE support the AND clause?

Doesn't MySQL DELETE support the AND clause?

It does.