Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
Rails pg jsonb column search method
# heading jsonb cloumn, and title a field inside jsonb search in jsonb
# heading: { title: "ABC" }
# For detail look at
q = "%#{search.downcase}%"
where("lower(heading ->> 'title') LIKE ?", q)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment