Actually, the INTERVAL() function uses a binary search to search for a number greater than the number of the first argument. So, that's why if we want the INTERVAL() function to work efficiently, the list of numbers will be in ascending order. Here is a good way to use the INTERVAL() function -
mysql> Select INTERVAL(50,20,32,38,40,50,55);
The above is the detailed content of Why are numbers in the MySQL INTERVAL() function best written in ascending order?. For more information, please follow other related articles on the PHP Chinese website!