LIKE operator in the filter area

Hey George!

The Contains and Not contains fields do just that. Its equivalent to LIKE and NOT LIKE.

Hi Ram, thanks for the reply. I don’t think those two are the same. I am not sure but ChatGTP gave me this, lol.

“LIKE” and “CONTAINS” operators are different in their primary purposes and use cases.

LIKE Operator:

Purpose: Used for pattern matching in strings.
Wildcard Characters: Allows the use of ‘%’ (matches any sequence of characters) and ‘_’ (matches any single character).
Example: SELECT * FROM employees WHERE name LIKE ‘John%’ to find names starting with “John.”

CONTAINS Operator:

Purpose: Primarily associated with full-text search capabilities.
Full-Text Search: Used for searching rows that contain a specific set of words or phrases.
Example: SELECT * FROM articles WHERE CONTAINS(description, ‘technology AND innovation’) to find articles containing both “technology” and “innovation.”

Hey George,

ChatGPT can be wrong more often than we think ??

In this case, I worked on this plugin originally, so I can assure you that Contains here is set to LIKE as I explained in previous response.

Can you give it a shot?

Ok, I hear you, thank you!