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 ).
Summary
In this chapter, you learned the basics of regular expressions and how to use
them in MariaDB SELECT statements via the REGEXP keyword.
 
 
Search WWH ::




Custom Search