like模糊查询,怎么在id前后加%?select * frominvigilators a left joinivgowner b on b.invigilatorid lik
like模糊查询,怎么在id前后加%? select * from invigilators a left join ivgowner b on b.invigilatorid like '%'a.id'%' 说写的有问题,请问这个%该怎么加啊? [解决办法] like '%' [解决办法] a.id [解决办法] '%' [解决办法] 字符串连接要用