About union sql Mysql 4.x

[HALIL DEMIREZEN]

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: [phone]
E-Mail/E-Posta: halil.demirezen@stripped
-----------------------------------------------------------