How can I perform a case-insensitive search in the p_any_emails array in Panther?

Last updated
Save as PDF

QUESTION

How can I perform a case-insensitive search on the p_any_emails array in Panther's Data Explorer?

ANSWER

You can utilize the ARRAY_TO_STRING function along with the ILIKE command. Here's an example of how you can achieve this:

SELECT *
FROM my_table
WHERE ARRAY_TO_STRING(p_any_emails, ', ') ILIKE '%email@example.com%'

In this example, the ARRAY_TO_STRING function is used to convert the array of emails (p_any_emails) into a string, separated by commas. The ILIKE command is then used for a case-insensitive pattern match on the resulting string.