使用[]转义
select * from ( select '我爱家乡的“西瓜树”%' as f union all select '我爱家乡' ) t where f like '%[%]%'
family as water