select * from `D_Topics` topic0_ where topic0_.createrID like '1%';
select * from `D_Topics` topic0_ where topic0_.createrID like '[10]%';
第一条能输出,第二条不行这是怎么回事啊
select * from `D_Topics` topic0_ where topic0_.createrID like '[10]%';
第一条能输出,第二条不行这是怎么回事啊
用regexp '[0-9]*';
- 若是正则的话,用 rlike, % 就是字面字符
- 若是sql的通配符的话,用 like, [10]就是字面字符
版主与rucypli都这么专业。
12.5.2. Regular ExpressionsTable 12.9. String Regular Expression Operators
Name Description
NOT REGEXP Negation of REGEXP
REGEXP Pattern matching using regular expressions
RLIKE Synonym for REGEXPA regular expression is a powerful way of specifying a pattern for a complex search.