ballouta Posted April 25, 2009 Share Posted April 25, 2009 Hello I have this query: SELECT * FROM `news` where `picture` !='NONE' order by Rand() limit 3 Is it possible to add for it another order statment? order by `created` ASC Thank You Quote Link to comment Share on other sites More sharing options...
Mchl Posted April 25, 2009 Share Posted April 25, 2009 Apart from that ORDER BY RAND() is not very good solution, yes it is possible SELECT * FROM (SELECT * FROM `news` where `picture` !='NONE' order by Rand() limit 3) AS subQry ORDER BY created Quote Link to comment Share on other sites More sharing options...
ballouta Posted April 25, 2009 Author Share Posted April 25, 2009 thanks alot Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.