sql 检索字符串

sql server:Charindex函数 charindex("字符串"，字段)

select * from [dbo].[TBL_AVALANCHE]    where  CHARINDEX('僵尸点',OUTDOORCODE)<=0

oracle 和mysql:instr函数 instr(字段，“”字符串“”)

select * from  tbl_jc_deviceinfo  where  instr(devicename,'CM')<=0