phpMyAdmin greater than search question

keat63

Well-Known Member
Nov 20, 2014
1,384
107
43
cPanel Access Level
Root Administrator
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

Well-Known Member
Jul 18, 2013
1,088
446
113
Spain
cPanel Access Level
Root Administrator

keat63

Well-Known Member
Nov 20, 2014
1,384
107
43
cPanel Access Level
Root Administrator
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)
 

Attachments

rpvw

Well-Known Member
Jul 18, 2013
1,088
446
113
Spain
cPanel Access Level
Root Administrator
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
 
  • Like
Reactions: cPanelLauren