Re: Unexpected result from floor() and rand()

2001-04-10 Thread Rene Tegel
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()

2001-04-09 Thread Churo Park
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 |