troubleshooting Question

Mysql regular expression to split Firstname and Lastname

Avatar of hugooguh
hugooguh asked on
MySQL Server
5 Comments1 Solution1201 ViewsLast Modified:
I have a users table and I would like to sort it using a regular expression (to split the firstname and lastname and to order it using the lastname)

Here’s the structure of the table users

id      fullname
1      "John, Smith"
2      "Paul, Brown"

Here’s what I want to achieve:

SELECT fullname FROM users ORDER BY "lastname of row fullname"
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros