In mysql, rand () can be used for random search.
Example [Query 10 data records randomly in the tt_dvjobs table]
Select * from 'tt _ dvjobs' order by rand () LIMIT 0, 10;
Practice has proved that modifying the function will cause very low query performance. Please use this function with Caution !!!
Articles you may be interested in
- How to query data of mysql today, yesterday, last 7 days, last 30 days, last month, and last month
- MySQL index Operation Command (create index, re-index, query index, delete index) Summary
- Summary of the causes and solutions for slow mysql Server Query
- Mysql converts unix timestamp to date format, and MySQL queries the current time
- Mysql queue for efficient Concurrent Data Reading
- MySQL uses limit 1 to improve query efficiency
- Jquery provides the ability to load data as the scroll bar scrolls.
- How does mysql export data of a field in a table?