开发者

MySQL Regular expression search

Iam struck with a search query in mysql, where i want to show a user's name like John-Chow, if i enter the search string in 开发者_如何学Gomy textbox as John Chow.

How to do this with mysql regular expression search ?


How about this:

  1. explode the textbox string in words

  2. use the following regex : words1.*?words2....*?wordsN

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜