My understand is that MYSQL only supports indexes on the beginning of a
string of data.
for example, if you have a list of email addresses, searching for
something like '%@yahoo.com' would need to do a full table scan.
why doesn't mysql offer a feature where it indexes by the END of the
string, so we can do these types of searches efficiently?
an index for email addresses of length 3 would only contain the last 3
chars, but it would still be a useful index type.
dave