题解 | #字符函数正则匹配1#
字符函数正则匹配1
https://www.nowcoder.com/practice/c2ab33676cc84e5593c6d337fd2b685f
/* 方案1:用LOCATE函数实现,返回子字符串在字符串中第一次出现的位置 */ SELECT id, comment FROM comment_detail WHERE LOCATE('是', comment) > 0 OR LOCATE('试', comment) > 0 OR LOCATE('报名', comment) > 0 ORDER BY id ASC ;
/* 方案2:用LIKE关键字实现,即对目标汉字实行模糊匹配 */ SELECT id, comment FROM comment_detail WHERE comment LIKE '%是%' OR comment LIKE '%试%' OR comment LIKE '%报名%' ORDER BY id ASC ;