#112 Select data -> search -> unable to use SQL functions

3.1.0
closed-fixed
Jakub Vrána
Common (150)
3
2011-01-30
2011-01-14
No

This is feature request.

when I view data from the table, I can't enter into search SQL functions like "CURDATE()" or "NOW()" and similar.
I can use it trough "edit SQL", but after that the view is not "native" to adminer, i.e. some things like editing fields does not work.

Possible solution:
Include into dropbox (=,>,<,...) also option "SQL function", then either keep textbox to write function by hand, or eventually do dropbox with function list (overkill IMHO).

Discussion

    • priority: 5 --> 3
     
  • Jakub Vrána
    Jakub Vrána
    2011-01-30

    Thank you for the report, I've fixed it in Git.

     
  • Jakub Vrána
    Jakub Vrána
    2011-01-30

    • status: open --> closed-fixed
     
  • Jakub Vrána
    Jakub Vrána
    2011-01-30

    There is now ability to search by an expression: 'modified > NOW()', 'modified > created' and even 'modified IS NULL OR modified < NOW()'.