mysql search unique values starting from the last row

Question

What I want is to search for a unique id (not the primary key) in a table where 99% of my searches for this unique id will be in the latest added rows.

So I want that my search begins from the last row to the first row. as the column is unique, when the search will start from the last row, the value will be found too much faster.

so the question is how can I obligate mysql to start searching in my procedure from the last row??

I found this question similar, or have same idea like my question but I didn't found any working answer.

any help is appreciated :))

Answer 1

If there is a date or ordered number associated with the time it was added and you only want to return a set # of rows then adding an index to that column and ORDER BY it DESC.

SELECT [COLUMNS] FROM [TABLE] WHERE [CRITERIA] ORDER BY [INDEX] DESC LIMIT [NUMBER]

I believe that will result in something similar to what you're looking for. Also adding indexes to the columns in your search criteria can speed up your query and help avoid FULL TABLE Scans.

Answer 2

what about something like this...only a guess

$query = "select searchkey from tablename where searchkey like %$searchtext% order by id desc";

Answer 3

SELECT DISTINCT (COLUMNNAME) FROM TBLNAME WHERE FIELDNAME LIKE %YOURVALUE% ORDER BY ID DESC