220. Regex basics

Regular expressions have 3 main purposes:

• filter database records that match a specific pattern
• extract parts of the text that match a specific pattern
• replace parts of the text that match a specific pattern

In the previous lesson we’ve learned that regular expressions (will be referred to as a regex or regexp) is just a way to specify a search pattern. From the database perspective, this search pattern is just a string value, for example: (A[\w\s]*\d{3,}[\w\s]*\?).

So how do we communicate our regex to the database to accomplish these...