Darkness Soul Posted July 19, 2006 Share Posted July 19, 2006 Yo,I have a col, VIP, and this one have my order method.. 'a', 'b', 'c'.I need to, randomize the data, after, order the randomized by this vip col.. after, i want to order the 'c' row by ASC, like this idea: ORDER BY RAND() , vip DESC , nome_fantasia ASC ( WHERE vip = 'c' )Some solution?Thanks,D.Soul Link to comment https://forums.phpfreaks.com/topic/15073-order-by-may-i-filter/ Share on other sites More sharing options...
fenway Posted July 19, 2006 Share Posted July 19, 2006 You want ORDER BY FIELD( vip, 'C' ) Link to comment https://forums.phpfreaks.com/topic/15073-order-by-may-i-filter/#findComment-60657 Share on other sites More sharing options...
Darkness Soul Posted July 20, 2006 Author Share Posted July 20, 2006 Hmmm.. thats a short one!What I've done to solute that problem was:[b]ORDER BY vip DESC , IF( vip = 'V' , RAND() , IF( vip = 'S' , RAND() , nomefantasia ))[/b]It works fine as wished! =)D.Soul Link to comment https://forums.phpfreaks.com/topic/15073-order-by-may-i-filter/#findComment-60974 Share on other sites More sharing options...
fenway Posted July 20, 2006 Share Posted July 20, 2006 That's much more work for the DB to do, especially the RAND()... not ideal,IMHO. Link to comment https://forums.phpfreaks.com/topic/15073-order-by-may-i-filter/#findComment-61103 Share on other sites More sharing options...
Darkness Soul Posted July 20, 2006 Author Share Posted July 20, 2006 yeah, I know.. and this order is with a union inside the sql string.. but.. they want it, they get it.. =)D.Soul Link to comment https://forums.phpfreaks.com/topic/15073-order-by-may-i-filter/#findComment-61313 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.