Limiting records in MySQL changes order of records?

Asked May 02 '17 at 10:48

Active May 02 '17 at 10:57

Viewed 26 times

I am trying this query to get some records:

select *
from `inbox`
where (
`user_id` = '00000000000000000000000000000001'
or `user_id` = '' 
and exists (
    select * 
    from `inbox_user` 
    where `inbox_user`.`inbox_id` = `inbox`.`id` 
    and `user_id`= '00000000000000000000000000000001'
))
order by inactive_percentage DESC

This gives me back this result:

As soon as I add limit 10 to the end it gives me this result:

This doesn't make sense to me at all. According to me I should have ids 256 - 2560 but limiting changes the result and gives me the results from the end of the table. What is going on here? I tried top also but it says syntax error. How do I work around this?

edited May 02 '17 at 10:57

Blank

12,308
1
14
32

asked May 02 '17 at 10:48

Rohan

13,308
21
81
154

What is the value for `inactive_percentage` on those rows? – TZHX May 02 '17 at 10:52
1

fyi `where a=b or a=c and x` is not the same as `where (a=b or a=c) and x` its likely you want the latter. – Alex K. May 02 '17 at 11:10
Yeah I didn't see that, you have a good point @AlexK. – Rohan May 02 '17 at 12:11
100 is the inactive_percentage for all – Rohan May 02 '17 at 12:11

Limiting records in MySQL changes order of records?

0 Answers0