Database Reference
In-Depth Information
Tip
Simple Regular Expression Testing You can use
SELECT
to test regular expressions
without using database tables.
REGEXP
checks always return
0
(not a match) or
1
(match). You can use
REGEXP
with literal strings to test expressions and to experiment
with them. The syntax would look like this:
SELECT 'hello' REGEXP '[0-9]';
This example would obviously return
0
(as there are no digits in the text
hello
).
In this chapter, you learned the basics of regular expressions and how to use
them in MariaDB
SELECT
statements via the
REGEXP
keyword.