帮忙修改SQL
select m.apply_person,m.dts_no,m.version_no, g.duty_person,g.group_id,s.station_name from param_monad as m join (select group_id,station_id,duty_person from param_group) g on g.group_id = m.group_id join param_station as s on g.station_id = s.station_id
where m.id = 75 and
s.station_name like '%'m.station_name'%'
主要的问题是
s.station_name like '%'m.station_name'%'这里怎么写？m.station_name 前面查询的表字段
谢谢
[解决办法]
s.station_name like '%m.station_name%'
[解决办法]
where instr(s.station_name,m.station_name)>1
[解决办法]
like的语法是----》like '%字符串%'
[解决办法]
s.station_name like concat('%',m.station_name,'%')
[解决办法]
s.station_name like concat('%',m.station_name,'%')
or
instr(s.station_name,m.station_name)>1
无法用到索引
