select whit random? help :)

select whit random? help :)

10-14-2009, 08:31 AM

[eluser]davidbehler[/eluser]
Try

Code:
select * from table_name order by rand() limit 0, 3

That would return 3 random rows from your table

Messages In This Thread

select whit random? help :) - by El Forum - 10-14-2009, 08:26 AM

select whit random? help :) - by El Forum - 10-14-2009, 08:31 AM

select whit random? help :) - by El Forum - 10-14-2009, 03:35 PM

select whit random? help :) - by El Forum - 10-14-2009, 04:14 PM