查询sq字段逗号分隔的方式

2,3,4


--

select * from t_qs_anlycomagingconfig t
where


and (

to_char(','||t.valid_month||',') like '%,2,%' or

to_char(','||t.valid_month||',') like '%,3,%' or

to_char(','||t.valid_month||',') like '%,4,%'

)

原文地址:https://www.cnblogs.com/yisheng/p/9941455.html