Request such

SELECT * FROM records WHERE state='NULL' LIMIT 25

Selects 25 lines, but skips the first and the 5th, despite the fact that state is there = NULL Then I updated the data in the selected lines, that's what happened enter image description here

    1 answer 1

    If sorting by ORDER BY is not specified, the order of selecting records is undefined and can be arbitrary.