FranklinWH-Toolbox/service/database/sql/queryDev.sql

SELECT * 
FROM iot_gateway 
WHERE active_status = 1 
  AND country = 'United States'
  AND province = 'California'
  AND version LIKE 'V10R10B30D00%' 
  AND run_status BETWEEN 0 AND 2 
  AND elecnet_status = 0
  AND id LIKE '1006%'
--   AND (
--     (
--         -- 模糊匹配 '10050011' 开头的字符串
-- 		fhp_sn LIKE '10050011%'
-- 		OR fhp_sn LIKE '%,10050011%'
--     ) AND (
--       	-- 同时匹配 '10050015' 或 '10050018' 作为开头的字符串
--     	fhp_sn LIKE '10050015%'
-- 		OR fhp_sn LIKE '%,10050015%'
--       	OR fhp_sn LIKE '10050018%'
-- 		OR fhp_sn LIKE '%,10050018%'
--     )
--   )
LIMIT 100