#916 Search using IN operator

fixed
nobody
1
2013-06-11
2006-05-03
Tim Lokot
No

It would be nice if on the search screen I could
search on a number using the IN operator. eg.

WHERE id IN (1,2,3)

At the moment you cant search on multiple distinct
values in the one field if its not a SET data type
but just an ordinary INTEGER.

Discussion

  • 2m

    2m - 2010-03-23

    Hey, even this is really old, I would like to implement this. It would be great exercise for me in a process of getting to know PMA code.

    I think user could provide values in the same format as it has to provide values when creating column of SET type. That is separated by commas. I would also think to add IN and NOT IN to operators select box.

     
  • Marc Delisle

    Marc Delisle - 2010-03-23

    Yes, good luck!

     
  • Michal Čihař

    Michal Čihař - 2011-03-02
    • priority: 5 --> 1
    • status: open --> pending
     
  • Michal Čihař

    Michal Čihař - 2011-03-02

    I can see searching using IN on tbl_select.php, so I believe this is already implemented.

     
  • SourceForge Robot

    This Tracker item was closed automatically by the system. It was
    previously set to a Pending status, and the original submitter
    did not respond within 14 days (the time period specified by
    the administrator of this Tracker).

     
  • SourceForge Robot

    • status: pending --> closed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed --> fixed
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks