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:
So how do we communicate our regex to the database to accomplish these...