【PostGresql】------- 模糊(like)+SQL语句查询

1.模糊(like) +SQL语句

SELECT * FROM "ORG_DEPARTMENT" WHERE   "CODEPATH" LIKE (select  "CODEPATH" from 
 "ORG_DEPARTMENT" WHERE "ID"='df51817ebf704ede898cd1795967a559')||'%'