Understanding Why MySQL Excludes Rows from Updates Using SELECT and UPDATE Queries with the Same WHERE Clause