JIYIK CN >

Keywords in any programming language such as C, C++, Java, and MySQL are useful; they are called reserved words. These reserved words have meanings and functions.

When these keywords are used in a statement, they operate according to their predefined behavior.

Select, Deleteand Whereare examples of reserved keywords. Based on the agreement decided before implementation, these words are displayed in the declaration and action is taken accordingly.

Table and variable names can never be similar to keywords, as they are reserved. No one can programmatically use these keywords in programming practice.

LikeEnforce case sensitivity of keywords in MySQL

likeThe keyword in MySQL whereis used with the keyword. Its function is to match a specific pattern.

Use wildcards or glob characters to identify these patterns.

In programming languages, a wildcard is a symbol that has a meaning and is used for pattern recognition. There are two types of wildcards used in MySQL.

These symbols can be used liketo group and combine in clauses.

LIKEThe syntax of the keyword:

SELECT * FROM table_name WHERE column_name LIKE 'ABC_';
SELECT * FROM table_name WHERE column_name LIKE 'T_ST%';

The above syntax uses likekeywords and wildcard characters to search for some defined set of values ​​from a table.

likeThe nature of the operation is that it ignores the case of the words and tries to find a match.

likeOne way to implement a case-sensitive comparison using :

If the user requires wherea more exact case-sensitive match in the clause, use LIKE BINARYthe keyword.

Query and execute MySQL statement:

 select * from stu;
+------+---------+------------+
| id   | Name    | DOB        |
+------+---------+------------+
| 111  | Amit    | 1970-01-08 |
| 112  | Shushma | 0000-00-00 |
| 113  | Rami    | 2020-09-08 |
| 114  | Sam     | 2020-09-08 |
| 115  | tonny   | 2020-09-08 |
+------+---------+------------+

Refer to the table above like binaryfor the following two queries using the keyword.

Select * from stu where name LIKE BINARY 's%';
Select * from stu where name LIKE BINARY '%mi_';

The above query lists all the occurrences of the column name with characters between them mi. BINARYThe keyword acts as a case sensitive match lookup in the query.

%The and _special characters stuhave special meanings when finding matches for all result sets in the table.

The first query shows selectthat the query results in all rows namewhere the column sstarts with lowercase . Therefore, the first query has no output.

Likewise, when %mi_the query is tried again using the character, only one result is displayed, as shown in the following image.

The screenshot of the actual execution of the above query in MySQL is as follows.