Is there a way in Ruby on Rails I can filter records by array column matching elements of another array using LIKE [duplicate]

Is it possible to determine if an ARRAY column contains overlapping values from another array with the LIKE clause? The && operator works but the strings have to be exact matches q = “””select * from articles where keywords && ‘{“mortgage brokers”}’;””” // Exact match Is it possible to filter the keywords where rows contain values with substring, not the full string? […]

Continue Reading