I was told that searching a MySQL database is LIKE '%wordend'bad because it takes a lot of time.
What is the best way to search at the end of a field?
Should I make an extra field where the field to look back is stored in the reverse order, it seems to me a good idea, since it will give the advantage of indexing!
source
share