Skip to content

Instantly share code, notes, and snippets.

Embed
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 http://edgeguides.rubyonrails.org/active_record_postgresql.html#json-and-jsonb
def self.search(search)
q = "%#{search.downcase}%"
where("lower(heading ->> 'title') LIKE ?", q)
end
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.