MySQL fuzzy query based on underline

Make a little progress every day!

Note that there is no percent%

Two underscores:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/51/32/wKiom1Ri_v-Bt7POAAFfnsSSOrY276.jpg "title=" 111. JPG "alt=" wkiom1ri_v-bt7poaaffnsssory276.jpg "/>

Three underscores:

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/51/32/wKiom1Ri_xLzeLYcAAF8b6kfBQA161.jpg "title=" 22.jpg "alt=" Wkiom1ri_xlzelycaaf8b6kfbqa161.jpg "/>

Related:

% represents any number of characters _ represents a character in MySQL, SQL mode defaults to case-insensitive

_: Represents any single character. Matches a single arbitrary character, which is commonly used to restrict the expression's character-length statement: ( which can represent one Chinese character )

Reference:

http://blog.csdn.net/my2010sam/article/details/19109235

This article is from "Phper Xuchen-Focus on PHP Technology" blog, be sure to keep this source http://xuqin.blog.51cto.com/5183168/1575689

MySQL fuzzy query based on underline