CodingForums.com - View Single Post

Old Pedant · 01-02-2013, 10:13 PM

Code:

SELECT * FROM Posts 
WHERE User = 'admin' 
AND Number >= ( SELECT Number FROM POSTS WHERE POST = 'soctqr26i7aycza2u73pi')
ORDER BY Number
LIMIT 25

???

It would have helped if you have shown the field names for each of those columns. And/or if you had used SELECT field1, field2, field3, ... instead of SELECT * (which you shouldn't use, if possible).

01-02-2013, 10:13 PM	PM User \| #2
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,168 Thanks: 59 Thanked 3,992 Times in 3,961 Posts	Code: SELECT * FROM Posts WHERE User = 'admin' AND Number >= ( SELECT Number FROM POSTS WHERE POST = 'soctqr26i7aycza2u73pi') ORDER BY Number LIMIT 25 ??? It would have helped if you have shown the field names for each of those columns. And/or if you had used `SELECT field1, field2, field3, ...` instead of `SELECT ` (which you shouldn't use, if possible). __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is. Last edited by Old Pedant; 01-02-2013 at 10:15 PM..*