[Phpmyadmin-devel] Support for LIKE %...% operator while searching numeric fields in table search screen
marc at infomarc.info
Mon Oct 8 23:10:34 CEST 2012
Le 2012-10-08 14:24, Chanaka Dharmarathna a écrit :
> 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 . Any thoughts on this ?
>  :
> Regards !
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.
More information about the Developers