Hints to optimise SQL queries with LIKE (vettabase.com)

I wrote some hints on how to optimise #SQL queries containing LIKE. More ideas, including unconventional ones, are very welcome - just comment here or on the website.