Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Regex again in SQL

jael91407431
Level 3
Level 3

Hi,

In MySQl, we have the ability to query using regex expressions, like:

mysql > SELECT name, name LIKE '%ns' ends_in_ns
-> FROM department;

...which yields:

ends.png

This example retrieves all the department names (fields) that name ends in “ns” as in "Operations," "Loans."

My question is, can we also include regex expressions as part of the value (SQL equivalent of "LIKE" or "INCLUDES," etc. plus regex (for example, "j%n.com" to include all email addresses starting with "j" and ending in "n") to query in the Query activity?

3 Replies
shrawans3153003
Employee
Employee

Hi,

Could you please provide some more details where are you trying to implement this use case.

Are you trying to create a query using regex expressions in Adobe Campaign Console

Amit_Kumar
Community Advisor
Community Advisor

In Adobe campaign query can be achieved with like operator.

1436751_pastedImage_0.png

Regards,

Amit