MySql underscore wildcard optimization -
hey, i'm trying optimize select char statement in mysql.
i aware using like '%text%' not optimizable, can underscore wildcard used in sort of optimization?
for instance want such as:
select * tbl col '_a_b_'
is there way optimize sort of query if never use % wildcard?
no. thing can in case - create field, contains same data without first letter , find where col_cut 'a_b_'
. , maintain triggers.
Comments
Post a Comment