Finds all rows where the value of the column matches any of the specified patterns (case-insensitive)