Comparison of relational database management systems. The following tables compare general and technical information for a number of relational database management systems.
Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs. General information[edit] MySQL Regular Expressions with The REGEXP Operator. MySQL's support for regular expressions is rather limited, but still very useful.
MySQL only has one operator that allows you to work with regular expressions. This is the REGEXP operator, which works just like the LIKE operator, except that instead of using the _ and % wildcards, it uses a POSIX Extended Regular Expression (ERE). Despite the "extended" in the name of the standard, the POSIX ERE flavor is a fairly basic regex flavor by modern standards. Still, it makes the REGEXP operator far more powerful and flexible than the simple LIKE operator. 11.4.2 Regular Expression.