1.%——表示可以匹配任意字符任意次数。
示例:select name from user where name like 'John%';
2._(下划线)——匹配单个字符
示例:select name from user where name like 'J_hn';
1.%——表示可以匹配任意字符任意次数。
示例:select name from user where name like 'John%';
2._(下划线)——匹配单个字符
示例:select name from user where name like 'J_hn';