通配符

In software, a wildcard character is a kind of placeholder represented by a single character, such as an asterisk (*), which can be interpreted as a number of literal characters or an empty string. It is often used in file searches so the full name need not be typed.

简单来说, 使用通配符来进行模糊查询

% 通配符

% 通配符用于匹配任意长度的字符串，包括零长度，在查询文章标题、用户名等此类字段时，会非常有用。

* 通配符

代表匹配所有值

? 参数占位符

插值表达式传参使用