While you are absolutely correct that this won't scale, and doesn't have a lot of advanced features like faceting and synonyms, it's still a useful technique. I use the SQL LIKE operator all the time, especially when I just need a simple way of searching my data.
If you under a million rows, LIKE is reasonably performant.
If you under a million rows, LIKE is reasonably performant.