lundi 31 juillet 2017

Generate random results every time in mySQL

I have read multiple articles int he forum those were really helpful however does not help me in achieving my target.

I want to generate a random number every time I query, with the query suggested "SELECT myUnique_id from My_table where EID = '1234' and entry_date = '2017-08-01' order by rand()"

Generates same number every time I run this query, but I want to change the number every time the query is executed.

Please help.




Aucun commentaire:

Enregistrer un commentaire