pgsql实现find_in_set

2022-08-08 10:25:06 阅读:1 编辑

mysql

select privilege_pusher_show from ims_zhyshop_sun_goods where FIND_IN_SET(
                '0',
                privilege_pusher_show
            )

pgsql

select privilege_pusher_show from ims_zhyshop_sun_goods where 
'0'=ANY(string_to_array(privilege_pusher_show,','))