MySQL select 10 random rows from 600K rows fast?

How can I best write a query that selects 10 rows randomly from a total of 600k?


How do I see what character set a MySQL database / table / column is?

What is the (default) charset for: - MySQL database - MySQL table - MySQL column

Still looking for help? Get the right answer, fast.

Ask a question for free

Get a free answer to a quick problem.
Most questions answered within 4 hours.


Find an Online Tutor Now

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.