Finds all rows where the value of the column matches the specified pattern using pattern matching (case-insensitive)