RLIKE REGEX - 返回给定值而不匹配空格

Question

I am trying to make a simple regex expression for a master search in my MYSQL query.

All I want to do is return a match even if the value has spaces in it and my search value does not.

E.G.

If the user enters 'JoeBlogs' and I try to match this against the clients full name I wish the client to be returned even if there is a space between joe and blogs. Joe Blogs

Did not want to use REPLACE in my where clause as I know this can be quite expensive.

Currently just looking for exact matches like so.

WHERE client_name RLIKE '^joeblogs'

I assume this would be quite simple with regular expressions but have not yet got around to learning regex's

Thank you

Answer 1

REGEXP 'Joe ?Briggs'

The question mark says that the char before it is optional.

If you need it "anchored":

REGEXP '^Joe ?Briggs$'

Now nothing can exist before or after the name. That is, "Joe Briggsworth" will not match.

For finding the name in the middle of a string and at word boundaries:

REGEXP '[[:<:]]Joe ?Briggs[[:>:]]'