mysql变量匹配

100 阅读1分钟
  • like

select * from users where id like '%2%'; # % 匹配多个
select * from users where id like '_2_'; # _ 匹配单个