Home >Database >Mysql Tutorial >How to query case sensitivity in mysql

How to query case sensitivity in mysql

WBOY
WBOYOriginal
2022-01-12 10:26:235384browse

In mysql, you can use the binary keyword to query case-sensitive. The function of this keyword is to make case-sensitive in the query statement. The syntax is "select * from table name where binary field name like 'query field ';".

How to query case sensitivity in mysql

The operating environment of this tutorial: windows10 system, mysql8.0.22 version, Dell G3 computer.

How does mysql query case sensitivity

MySQL query is not case-sensitive by default. If you need to be case-sensitive, you must query An example of adding binary

before the condition is as follows:

How to query case sensitivity in mysql

How to query case sensitivity in mysql

How to query case sensitivity in mysql

How to query case sensitivity in mysql

##Recommended learning:

mysql video tutorial

The above is the detailed content of How to query case sensitivity in mysql. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn