REGEXP_SIMILAR Function Example | Teradata Vantage - Example - Advanced SQL Engine - Teradata Database

The following query:

SELECT name FROM customers WHERE REGEXP_SIMILAR(name, '(Mike B(i|y)rd)| (Michael B(i|y)rd)', 'c') = 1; 

returns the names from the customers table that match:

• 'Mike Bird'
• 'Mike Byrd'
• 'Michael Bird'
• 'Michael Byrd'

The matching is case sensitive.