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