MySql表数据中含有通配符的查询 table: example idname1*A2*B3AB Sql: select * from example where ’2B’ REGEXP CONCAT_WS(REPLACE(name,’*’,’.*’),’^’,’$’);