MariaDB 10.3

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

10.3.36-MariaDB-1:10.3.36+maria~deb10-log

SELECT '"Word"' REGEXP '(?-i)\\bword\\b' AS case_sensitive;

case_sensitive

0

SELECT '"Word"' REGEXP '(?-i)\\bWord\\b' AS case_sensitive;

case_sensitive

1

SELECT '"Word"' REGEXP '(?i)\\bword\\b' AS case_insensitive;

case_insensitive

1

SELECT '"Word"' REGEXP '\\bword\\b' AS case_insensitive;

case_insensitive

1