#191 (in 2.6.0) a patch to search faster in one table

closed-accepted
Interface (183)
1
2004-09-27
2004-04-21
No

i move this here from the help forum (i posted it there
before on
http://sourceforge.net/forum/forum.php?thread_id=1053187&forum_id=72909
)

usually if you use the search function in phpmyadmin,
you write a word and every time, you have to add the
'%' before and after the searchword.
this should be optional for non-text fields. 'LIKE'
should be the second option and a new option is fist
'search' which just means, that you don`t have to add
the '%'

to add it to your myadmin, change this in the script
tbl_select.php:
change line 39 from
$textfunctions = array('LIKE', '=', '!=');
to
$textfunctions = array('search', 'LIKE', '=', '!=');

and add this:

if ($func[$i]=='search') {
$func[$i]='LIKE';
$fields[$i]='%'.$fields[$i].'%';
}
to line 282, before
$sql_query .= ' AND ' .
PMA_backquote(urldecode($names[$i])) . ' ' . $func[$i]
. ' ' . $quot . PMA_sqlAddslashes($fields[$i]) . $quot;

Discussion

  • Ruben Barkow

    Ruben Barkow - 2004-05-01

    Logged In: YES
    user_id=334647

    can i try implement this in the CVS?

     
  • Ruben Barkow

    Ruben Barkow - 2004-05-01
     
  • Marc Delisle

    Marc Delisle - 2004-05-03
    • assigned_to: nobody --> lem9
     
  • Marc Delisle

    Marc Delisle - 2004-05-03

    Logged In: YES
    user_id=210714

    I like the idea. However, instead of putting "search"
    (anyway it would have to be $strSearch), and because the
    column title is now "operator", maybe we could put this in
    the choice:

    LIKE %...%

     
  • Ruben Barkow

    Ruben Barkow - 2004-05-04

    Logged In: YES
    user_id=334647

    sounds good, and this as default is very handy, cause
    usually you are looking for something within one of the strings

     
  • Marc Delisle

    Marc Delisle - 2004-05-05
    • priority: 5 --> 1
    • summary: a patch to search faster in one table --> (in 2.6.0) a patch to search faster in one table
    • status: open --> open-accepted
     
  • Alexander M. Turek

    • status: open-accepted --> closed-accepted
     

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

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks