Re: Unexpected result from floor() and rand()
ber, title from t_board order by rand() limit 1; gl - Original Message - From: "Churo Park" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, April 10, 2001 3:50 AM Subject: Unexpected result from floor() and rand() > I've made a query and got a g
Unexpected result from floor() and rand()
I've made a query and got a good result like these: mysql> select bid, number, title from t_board mysql> where bid = 'test' and number = floor(rand()*100)+1; +--++---+ | bid | number | title | +--++---+ | test |