I have database with table and 1 milions random characters. Key for
searching each character is a counter from 1 to milion.
when I execute statement:
SELECT count, character FROM table_name WHERE count=ROUND(rand()*100000);
Example:
count || character ||
1 dasarewr
2 adswarwrf
3 sfdqwerw
4 dfweqrqwe
5 asdfwerdfwe
6 fdwerwer
7 fsdwefwe
8 frefer
... .....
9999 daswer
1000 fdferte
.... .....
999999 asdwerer
1000000 dasrewg
RESULT:
1) Sometimes I get just one result like:
4352342 dcfsfwer
2)Sometimes I get TWO results!
1000 fdferte
999999 asdwerer
3) sometimes even THREE
....
4) sometimes NONE
The select statement must to gave me just ONE result!
Does anyone know what that is about? Does ROUND() have any bugs?
Sorry for bad english.
Elvir
---end of your message-------
MySQL Development Team
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php