With the help of range search feature, one can specify a range of values for particular column(s) while performing search operation on a table from the Search tab.
To use this feature simply click on the BETWEEN or NOT BETWEEN operators from the operator select list in front of the column name. On choosing one of the above options, a dialog box will show up asking for the Minimum and Maximum value for that column. Only the specified range of values will be included in case of BETWEEN and excluded in case of NOT BETWEEN from the final results.
Note: The Range search feature will work only Numeric and Date data type columns.
Posted in: PhpMyAdmin