SELECT "string" REGEXP "some regex";

##</code><code>##

SELECT col1, col2, ... FROM table WHERE col1 REGEXP 'your regex'