加了个like出错了？

[jilong4]

这个是对的
execute('select * from users ')
加了个like就出错
execute('select * from users where id like '1%' ')

[victorycyz]

execute('select * from users where id like ''1%'' ')

[lingli99]

execute('select * from users where id like '1%' ') id必须是字符型，才可用like

[lingli99]

execute('select * from users where id like "1%" ')id必须是字符型，才可用like

[zjmym]

execute('select * from users where left(id,1) =1')

[软件钢琴师]

同意
execute('select * from users where id like '1%' ') id必须是字符型，才可用like