Regex again in SQL

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

06-11-2017

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?

Replies

Highlighted

Avatar

Avatar

shrawans3153003

Employee

Avatar

shrawans3153003

Employee

shrawans3153003
Employee

07-11-2017

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

Highlighted

Avatar

Avatar

jael91407431

Avatar

jael91407431

jael91407431

07-11-2017

Yes, exactly.

Highlighted

Avatar

Avatar

Amit_Kumar

MVP

Avatar

Amit_Kumar

MVP

Amit_Kumar
MVP

08-03-2018

In Adobe campaign query can be achieved with like operator.

1436751_pastedImage_0.png

Regards,

Amit