PHP and PostgreSQL. Advanced Web Programming2002

Regular expressions are an old and hence reliable feature of PHP and PostgreSQL. The power of regular expressions helps you to retrieve complex strings with just a few lines of code.

One problem when working with regular expressions is that no indexes can be used. Especially when dealing with large amounts of data, this can be a problem.