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

Popular posts from this blog

asp.net - repeatedly call AddImageUrl(url) to assemble pdf document -

java - Android recognize cell phone with keyboard or not? -

iphone - How would you achieve a LED Scrolling effect? -