MYSQL中怎么实现 like ‘[1,2,3,4]%’呢

MYSQL中如何实现 like ‘[1,2,3,4]%’呢?

MySQL   中如何实现   like   ‘[1,2,3,4]% ‘   呢?

查询出的结果应该是:

100

102

200

301

203

403

用法相同吧




正则表达式

1d+|2d+|3d+|4d+




select * from table_name where conditon like ‘1% ‘ or condition lide ‘2% ‘;




regexp ‘[1,2,3,4]% ‘