mysql find in set 函数在pgsql中的函数写法
mysql中的写法:select *from folder f,uploads uwhere u.id=f.folderIdandFIND_IN_SET(‘8’, ‘15,9,13,27’)在pgsql中的写法:select *from folder fjoin uploads u ON u.id = f.folderIdwhere‘8’ = ANY (string_to_array(some_c
·
mysql中的写法:
select * from folder f,uploads u
where u.id=f.folderId
and FIND_IN_SET(‘8’, ‘15,9,13,27’)
在pgsql中的写法:
select * from folder f join uploads u ON u.id = f.folderId where
‘8’ = ANY (string_to_array(some_column,’,’))
更多推荐
已为社区贡献1条内容
所有评论(0)