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