MySQL/Tutorials

MySQL tutorial

Queries

String functions

Pattern Matching

Using RegExp

Regular expressions in SQL

--------------------------

Lets create a table.

create table address (name varchar(20));
insert into address values ("people"),("places"),("things"),("ppl");

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

select * from address where name RegExp "[p]{2}" 
+--------+
| name   | 
+--------+
| ppl    |
+--------+

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