[PostgreSQL] 키워드 검색

검색어 포함시키고 싶을때

1. SIMILAR TO '%(#{}|#{}|#{})%'

SELECT * FROM
name SIMILAR TO '%(민수|민아|경아)%'

2. LIKE '%'||#{}||'%'

name NOT LIKE '%'||민수||'%' OR name NOT LIKE '%'||민아||'%' OR name NOT LIKE '%'||경아||'%'

검색어 제외시키고 싶을때

1. NOT SIMILAR TO '%(#{}|#{}|#{})%'

SELECT * FROM
name NOT SIMILAR TO '%(민수|민아|경아)%'

2. NOT LIKE '%'||#{}||'%'

name NOT LIKE '%'||민수||'%' OR name NOT LIKE '%'||민아||'%' OR name NOT LIKE '%'||경아||'%'