phpMyAdmin greater than search question

[keat63]

In PHP MyAdmin, i'm tring to perform a search where one column is 'Like %...%'
and another column is greater than a given value.

I can't seem to find how to perform a greater than search.

Any ideas please ?

 

[rpvw]

= equals
>= equals or is greater than
> greater than

I believe that these are only available to operate on numerical data in phpMyAdmin

MySQL :: MySQL 8.0 Reference Manual :: 12.3.2 Comparison Functions and Operators

 

[keat63]

MyAdmin doesn't appear to allow free input when using the search tab.
I could use this using an SQL command but not by the search tab. (see attached)

I found that I can use the operator 'BETWEEN' which in effect does the same thing, but not greater than. (or less than)

 

[rpvw]

That's because the field you are trying to search on is not a number 'Type' - try again in an int or tinyint and you will see the mathematical operands in the Operator dropdown

 

[cPanelLauren]

Hi @keat63


Can you confirm whether or not the advice provided by @rpvw helped resolve the issue?

Thanks!