[Phpmyadmin-devel] Support for LIKE %...% operator while searching numeric fields in table search screen

Marc Delisle marc at infomarc.info
Mon Oct 8 23:10:34 CEST 2012

Le 2012-10-08 14:24, Chanaka Dharmarathna a écrit :
> Hi,
> Currently there is no 'LIKE %...%' operator for the numeric fields in table
> search screen. But there are some scenarios we need to search the numeric
> fields (int, date etc) with 'LIKE' operator + wildcard characters (LIKE
> %2012%). So, was there any reason for not using that previously ?
> If we can give the support for this, it hopefully provide a different way
> to bypass the problem in bug [0]. Any thoughts on this ?
> [0] :
> https://sourceforge.net/tracker/index.php?func=detail&aid=3573456&group_id=23067&atid=377408
> Regards !

Hi Chanaka,
I don't see a reason for not offering this (but take care of not showing
this option by default, as the leading % wildcard bypasses any index.

Marc Delisle

More information about the Developers mailing list