Use of the "MySQL" Fuzzy query

1.like/not fuzzy query with the LIKE keyword (SQL mode)

Base Template: SELECT * from test WHERE name like '% Hello _ ': match xxxxxxx How are you?

A wildcard describes:

①% denotes any number of characters

②_ denotes an arbitrary character

2.regexp/not regexp keyword's fuzzy query (regular mode)

Base Template: SELECT * from test WHERE name REGEXP ' ^ab[cde]fg$ ': Match ABDFG abcfg ABEFG

Wildcard description (same regular expression):

①^ denotes what begins with, put in the beginning

②$ indicates what ends with, put at the end

③[... ] matches any one of these characters

④[^... ] do not match any one of these characters

⑤. Match any one character (except \ n)

⑥| To express the meaning of logic or

⑦* represents at least 0 characters, equivalent to {0,}

⑧+ represents at least 1 characters, equivalent to {1,}

⑨{n} means matching n of this character

⑩{n,m} indicates a match of at least N, up to M characters

Use of the "MySQL" Fuzzy query