phpMyAdmin greater than search question

keat63

• March 15, 2019 03:53

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

  • March 15, 2019 09:29

  = equals >= equals or is greater than > greater than I believe that these are only available to operate on numerical data in phpMyAdmin

  0
• 

  keat63

  • March 15, 2019 11:45

  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)

  0
• 

  rpvw

  • March 15, 2019 11:57

  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

  0
• 

  cPanelLauren

  • March 15, 2019 20:46

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

  0

Please sign in to leave a comment.