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
1 "John, Smith"
2 "Paul, Brown"
Here’s what I want to achieve:
SELECT fullname FROM users ORDER BY "lastname of row fullname"