[Phpmyadmin-devel] using db_search

Robin Johnson robbat2 at orbis-terrarum.net
Mon Nov 18 17:23:04 CET 2002


On Mon, Nov 18, 2002 at 03:10:13PM -0500, Marc Delisle wrote:
> 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%')
Yes. I think this is a bug that got introduced by somebody along the
way, as it used to put in the wildcards. So we should put them back now.

-- 
Robin Hugh Johnson
E-Mail     : robbat2 at orbis-terrarum.net
Home Page  : http://www.orbis-terrarum.net/?l=people.robbat2
ICQ#       : 30269588 or 41961639
GnuPG FP   : 11AC BA4F 4778 E3F6 E4ED  F38E B27B 944E 3488 4E85
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 232 bytes
Desc: not available
URL: <http://lists.phpmyadmin.net/pipermail/developers/attachments/20021118/9da528de/attachment.sig>


More information about the Developers mailing list