MYSQL is required. You must use wildcards to filter Reading Notes in Chapter 8. mysql is required.

MYSQL is required. You must use wildcards to filter Reading Notes in Chapter 8. mysql is required.

Mysql Introduction

MySQL is an open-source Relational Database Management System (RDBMS). the MySQL database system uses the most common database management language-Structured Query Language (SQL) for database management.

Tips for using wildcards:

1. Do not over-use wildcard characters. If other operators can achieve the same effect as wildcards, other operators should be given priority.

2. Do not use wildcards at the beginning of the search mode unless they are absolutely necessary. Place the wildcard at the beginning of the search mode, and the search is the slowest.

3. Pay attention to the location of the wildcard. If an error occurs, the expected result may not be returned.

Note:

Case Sensitive:Based on the MySQL configuration method, the search can be case sensitive. If case sensitive, 'Jet % 'does not match JetPack 1000.

Note:Trailing space may interfere with wildcard matching

Note that although % can match anything, NULL is an exception, that is, NULL. Even where prod_name LIKE '%' cannot match the line with the value NULL as the product name.

% Of the wildcards used match 0 or multiple characters. _ Can only match one character.

The above content is a small Editor to introduce you to MYSQL, you must know the Reading Notes, Chapter 8 using wildcards for filtering knowledge, I hope to help you!