how to fetch data from database randomly?

Question

Right now i am just using simple query to fetch data but it fetching like the way i store in database linewise . But i want to fetch randomly but how ??

here is my query

Select * from FOOD where food_price <= ?

Possible Duplicate http://stackoverflow.com/questions/580639/how-to-randomly-select-rows-in-sql — Rohan Khude, Aug 15 '16 at 18:26

score 1 · Accepted Answer · answered Aug 15 '16 at 18:42

1

Try This...

Select * from FOOD where food_price <= ? ORDER BY RAND()

answered Aug 15 '16 at 18:42

Rahul Mukati

744
2
10
15

Paulo Matos · Answer 2 · 2016-08-15T19:11:13.393

0

If you want it in a range from 1 to 100:

SELECT * FROM FOOD WHERE food_price <= ? ORDER BY RAND()

edited Aug 15 '16 at 19:11

answered Aug 15 '16 at 18:24

Paulo Matos

91
6

and if i dont want it in range then ? – Utkarsh Sharma Aug 15 '16 at 18:42

score 0 · Answer 3 · answered Aug 15 '16 at 18:35

0

In SQL Server I use newid():

select *
from FOOD
where price <= ?
order by newid();

answered Aug 15 '16 at 18:35

dkolln

81
5

showing error Call to a member function bind_param() on a non-object – Utkarsh Sharma Aug 15 '16 at 18:56

how to fetch data from database randomly?

3 Answers3