Database substring indexes
Goals
Imagine you have an application that keeps track of domain names. And this
application has millions of entries in a MySQL database. How do you efficiently
find all domain names that have part of a word inside of them?
This article assumes some understanding of how SQL queries work.