MySQL/Tutorials

MySQL tutorial

Queries

String functions

Pattern Matching

Using RegExp

Regular expressions in SQL

Lets create a simple table.

CREATE table address (name varchar(20));
INSERT into address VALUES ("people"),("places"),("things"),("ppl");

Table address:
+--------+
| name   | 
+--------+
| people |
| places |
| things |
| ppl    |
+--------+

Look for two p's in a row.

SELECT * FROM address WHERE name RegExp "[p]{2}" 
+--------+
| name   | 
+--------+
| ppl    |
+--------+

A "." is any character. A "+" is one or more copies of a character. Look for two p's but not next to one another.

SELECT * FROM address WHERE name RegExp "p.+p" 
+--------+
| name   | 
+--------+
| people |
+--------+

Exercises

Give a sql regular expression query that will select:

1) only people and places 2) only ppl and places 3) only people and places 4) only things and places