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