Hi, I am trying to run an sql query such as below to list items=x randomly and then items != x randomly..
mysql> (select * from tablea where item=1 order by rand()) union all (select * from tablea where item != 1 order by rand()); but the result is not as expected. rand() seems not to be working... What can be the problem? or what can be the difference between my will and the exact result of the query? Thanks.. ------------------------------------------------------------ Halil Demirezen System Support Engineer/ Sistem Destek Muhendisi Mobile Tel/Cep Tel: +90(543) 502 04 42 E-Mail/E-Posta: [EMAIL PROTECTED] -----------------------------------------------------------