SELECT
*
FROM
file_record fr
LEFT JOIN log_project lp ON fr.ID = ANY ( lp.prj_files :: INTEGER [] )
WHERE
fr.is_del = 'N'
AND '吴某丹' = ANY ( string_to_array( fr.standarder_account_name, ',' ) )
AND '6214837800000537' = ANY ( string_to_array( fr.standarder_account, ',' ) );
standarder_account_name字段内容-> 4000032509200003106,41033100000008473,44201573600000005791,6228480128600007679
快速查询存储多个账号的test类型字段是否存在某账号(以逗号分隔)
语句: AND '6214837800000537' = ANY ( string_to_array( fr.standarder_account, ',' ) );