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.