Louis Davidson shows off some more of the power of regular expressions:
One of the practical uses of RegEx is more powerful filtering. One of the projects I am working on, (very slowly) is sharing some SQL utilities on GitHub, Utilities like looking at the metadata of a table, searching for columns, database sizes, etc. I usually use
LIKEto filter data, which lets me simply use an equality search, or I can also do a partial value search when I don’t know exactly what I am looking for.
LIKE is quite useful but, as Louis points out, it does have its limits. And in those limits is where regular expressions do so well.