The following MySQL query:

SELECT * FROM user WHERE name REGEXP '.*Noir';

It matches user name ‘Foo Noir’ and ‘Noir Bar’, but not ‘noir’.

To use case-insensitive match, use REGEXP_LIKE and add i flag:

SELECT * FROM user WHERE REGEXP_LIKE(name, '.*Noir', 'i');

Reference:

• MySQL - REGEXP, RLIKE - Guide, Examples and Alternatives

Author: Nobody

License: CC BY-NC-SA 4.0

Link: https://asdasd.page/2021/MySQL-Case-insensitive-Regex-Match/