Let's take a look at this SQL query to a MySQL database:
UPDATE `messages` SET `read`=1 WHERE `id`=1234;
Let's assume that
messages is a really long table and
id is auto increasing and primary key.
My question is:
Does MySQL automatically stop searching, when it finds one message with
id=1234? Or in other words: is there any point using
LIMIT in query like this one?