[Phpmyadmin-devel] using db_search

Marc Delisle DelislMa at CollegeSherbrooke.qc.ca
Mon Nov 18 12:11:13 CET 2002

I got a question from a user. He has a table with a field (nom)
containing first name and last name.
When he uses db_search, asking, for example, for

marc delisle

and with the option "at least one of the words", nothing is found.

The generated query contains:

WHERE (`nom` LIKE 'marc') OR (`nom` LIKE 'delisle')

Of course, if he puts wildcards in the search expression, it works,
but it seems not intuitive. It also works with search option 4 (regexp).

Shouldn't we add wildcards in db_search for word by word search,
so that the generated query had this condition:

WHERE (`nom` LIKE '%marc%') OR (`nom` LIKE '%delisle%')


More information about the Developers mailing list