我从前台接到一个值 $val = 1;
要从数据库 m字段 字段格式是 1234 , 23457 ,345678
我想要查询这些数中 开头是 值 1的 数
应该怎么查....
select * from table where m like '1%'
select * from 数据表名字 where m like '1%'
select * from [表名] where m like '1234%'
或者是select * from [表名] where m ='1234'
select * from [表名] where m ='1___'
1后面3个下划线,下划线匹配任意单个字符