Mysql query case

The case sensitivity issue of mysql queries is a common problem. We will analyze several common cases of mysql queries by case. I hope this will help you learn about the case sensitivity issue of mysql queries.

Mysql queries are case-insensitive by default, for example:

 
 

  
  
select    from   table_name where   a like   ' a'       
  
  
select    from   table_name where   a like   ' a'       
  
  
select   from table_name where a like ' a'   
  
  
select   from table_name where a like ' a'   
 
 

The results are the same.

To make mysql queries case sensitive, you can:

 
 

  
  
select    from   table_name where   binary   a like   ' a'       
  
  
select    from   table_name where   binary   a like   ' a'       
  
  
select   from table_name where binary a like ' a'   
  
  
select   from table_name where binary a like ' a'   
  
  
 
 
 

You can also identify a table when creating it.

 
 

  
  
create   table   table_name(     
  
  
       a varchar (20) binary       
  
  
)   
 
 

Implementation of MySQL random Query

Example of the number of MySQL query results

Optimization of MySQL query Paging

MySQL query results are sorted by a certain value

Use functions to query row numbers in MySQL