select id, name from region where MergerName like concat('%',(select name from region where id='150000'),'%') and name like '%市'
concat函数 拼接字符串
select id, name from region where MergerName like concat('%',(select name from region where id='150000'),'%') and name like '%市'
concat函数 拼接字符串