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 |