LIKE
运算符配合通配符 %
。SELECT * FROM table WHERE column LIKE '%pattern%'
。LIKE
运算符配合通配符 %
。SELECT * FROM table WHERE column LIKE '%pattern%'
。sql,SELECT * FROM table WHERE column LIKE '%' || :variable || '%';,
`,,这里,
:variable 是你要查询的变量,
'%' || :variable || '%' 表示在变量前后添加通配符
%` 来进行模糊匹配。LIKE
关键字。,,``sql,SELECT * FROM table_name WHERE column_name LIKE '%search_term%';,
`,,这条语句会查找
column_name 中包含
search_term` 的所有记录。Powered By Z-BlogPHP 1.7.3
Copyright Your WebSite.Some Rights Reserved.