How to query intermediate records in MySQL

The method for querying intermediate records in MySQL is not complex. The following describes how to query intermediate records in MySQL. If you have encountered any problem with querying intermediate records in MySQL, take a look.

Query the first five records in the table:

 
 

  
  
Select * from table 1 limit 5;
  
  
 
  
  
Select * from table 1 limit 0, 5;
  
  
 
 
 

Query 5th to 7th records in a table:

 
 

  
  
Select * from table 1 limit 4, 3;
  
  
 
 
 

Select a record:

 
 

  
  
Select * from table 1 order by rand () limit 1;
  
  
 
 
 

Select n records:

 
 

  
  
Select * from table 1 order by rand () limit n;
  
  
 
 
 

Transformed from the MySQL Query Class of discuz

How MySQL query optimizer works

Non-empty question in MySQL Query

MySQL query results are sorted by a certain value

Use functions to query row numbers in MySQL