mysql select limit 1,MySQL是否会“ SELECT LIMIT 1”有多个记录，从顶部选择第一个记录？...

I've searched and searched and can't find an answer to this question, I'm probably asking it in the wrong way.

I am querying an employee database.

I need to get details based on a position id, however there could be multiple records for that position id as this organisation has permanent employees and temporary employees that act against the same position.

So, in order to get the CURRENT occupant of the position id, I need my query to SELECT the FIRST record that matches the position string, from the the TOP DOWN.

will this select the first matched record from the top?

SELECT * WHERE `position_id`="00000000" LIMIT 1;

Thanks in advance.

解决方案

You need an ORDER BY clause to define the ordering between the individual records your table. If you do not use ORDER BY you can assume no fixed order between the records, and you could get a new order each time you executed the query.