Database query only returns max 30 results

pxoxrxn

Supreme Member
Joined
Dec 21, 2011
Messages
1,398
Reaction score
2,084
Hey, I just wrote a simple query for my MySQL DB to try extract all verified email addresses. The query looked like this:

SELECT *
FROM user
WHERE verified >0;

For some reason it only returns a handful of results and then adds a line to the bottom saying MAX 0,30. I changed it to 2000 and it does the same. I am expecting it to return 1500+ results.
 
SELECT * FROM user WHERE verified > 0 LIMIT 2000;

This should work.
 
you are using phpmyadmin probably considering the fact the limit 0,30 is auto added, right?

Simply use what Joppe said when using phpmyadmin, that should work.. if not using phpmyadmin your original query will be fine as well
 
it will show only 30.. u need to navigate to next page. or click on show all at bottom.
 
Back
Top