Say I have these rows in one
The first 6 digits are year and month (YYYYMM), and the XXXXX part are random digits. They are
UNIQUE. Let's say there are millions of rows like these.
I need to lookup a certain row e.g.,
20210312345, is there a way I could tell MySQL to not look at the whole table and just search on rows with the
202103 prefix? And, if that was possible, would it actually speed up the query?