Overqualified Query??

[Anon]

Why can't I perform this query:

SELECT field1, field2, field3
FROM table
WHERE field4="value"
LIMIT 4,1
ORDER BY field5

should return the fourth row only of the query without the limit... but it just wont go.?? can I not do Where and Limit in the same? How do i narrow my result to one select row?

Thanks,
S

[[deleted]]

I was able to perform this query by slightly adjusting it. Simply move the limit to the end...

SELECT field1, field2, field3
FROM table
WHERE field4="value"
ORDER BY field5
LIMIT 4,1

Matt Wade
codewalkers.com

[tomhath]

Along with putting the LIMIT after the ORDER BY as Matt suggests, do you want the fourth or the fifth row? The first number is the number of rows to skip, so it looks like you're trying to read the fifth record.