Find string item in Postgres array field (a.k.a type text[] )

October 21, 2024

Public

PostgreSQL

Given table orders has a field coupon_codes that is type text[] (Postgres Arrray)

example:

orders.coupon_codes
 ["abc", "yyyy"]

you can call

select * from orders where 'abc'=ANY(coupon_codes);