Vivid Lust Posted February 9, 2009 Share Posted February 9, 2009 With SQL, how can I select 3 random values "WHERE status='2'" ?? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/144489-random-values/ Share on other sites More sharing options...
nadeemshafi9 Posted February 9, 2009 Share Posted February 9, 2009 With SQL, how can I select 3 random values "WHERE status='2'" ?? Thanks. something along the lines of SELECT * FROM table WHERE status=2 ORDER BY RAND() LIMIT 3; Quote Link to comment https://forums.phpfreaks.com/topic/144489-random-values/#findComment-758178 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.