Re: Fast LIKE search

[Rick James]

No.

To execute that query (as you have written it), it has to read every row, and scan each name until it finds 30 hits. If there are not 30 hits in the table, it will have to read every row.

If 'uxyz' is a 'word', you can add a FULLTEXT index. Then, using
MATCH(name) AGAINST('uxyz' ...)
will run much faster than LIKE.

If you are not willing to go that way, I may be able to give you some slight improvements, but first please provide
* SHOW CREATE TABLE tbl\G
* SHOW TABLE STATUS LIKE 'tbl'\G
* EXPLAIN SELECT ...\G
and surround them with [ code ] and [ / code ]