Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

phpMyAdmin greater than search question

Discussion in 'Database Discussion' started by keat63, Mar 15, 2019.

  1. keat63

    keat63 Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    1,291
    Likes Received:
    91
    Trophy Points:
    28
    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 ?
     
    #1 keat63, Mar 15, 2019
  2. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    1,088
    Likes Received:
    442
    Trophy Points:
    113
    Location:
    Spain
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 rpvw, Mar 15, 2019
  3. keat63

    keat63 Well-Known Member

    Joined:
    Nov 20, 2014
    Messages:
    1,291
    Likes Received:
    91
    Trophy Points:
    28
    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)
     

    Attached Files:

    #3 keat63, Mar 15, 2019
  4. rpvw

    rpvw Well-Known Member

    Joined:
    Jul 18, 2013
    Messages:
    1,088
    Likes Received:
    442
    Trophy Points:
    113
    Location:
    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
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 rpvw, Mar 15, 2019
    cPanelLauren likes this.
  5. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,464
    Likes Received:
    505
    Trophy Points:
    263
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Hi @keat63


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

    Thanks!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #5 cPanelLauren, Mar 15, 2019
(You must log in or sign up to post here.)
Loading...
Similar Threads - phpMyAdmin greater search
  1. Mark Coates

    PHPMyAdmin view all databases on server

    Mark Coates, Jul 12, 2019 at 6:01 AM, in forum: Database Discussion
    Replies:
    3
    Views:
    73
    cPanelLauren
    Jul 15, 2019 at 1:25 PM
  2. Nabbello

    SOLVED Enable phpMyAdmin relation feature?

    Nabbello, Jul 8, 2019, in forum: Database Discussion
    Replies:
    2
    Views:
    99
    Nabbello
    Jul 9, 2019
  3. kabatak

    In Progress [CPANEL-28306] webmail and/or phpmyAdmin stuck at loading screen

    kabatak, Jul 6, 2019, in forum: EasyApache
    Replies:
    9
    Views:
    314
    kabatak
    Jul 16, 2019 at 2:41 AM
  4. JustWrappingMyHead

    Uninstall PhpMyAdmin?

    JustWrappingMyHead, Jun 27, 2019, in forum: Workarounds and Optimization
    Replies:
    1
    Views:
    125
    Infopro
    Jun 27, 2019
  5. GoWilkes

    phpMyAdmin forgets previous SELECT

    GoWilkes, Jun 26, 2019, in forum: Database Discussion
    Replies:
    1
    Views:
    151
    cPanelMichael
    Jun 28, 2019

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice