mysql - How can I use Substring and Replace in one SQL-Statement?

Question

SELECT TOP 1 REPLACE(name, '*Deleted*', '' )  FROM OBJ_R) AS lastname and
SELECT SUBSTRING(NAME FROM 1 FOR POSITION(',' IN NAME)-1) FROM OBJ_R

instead of Deleted Beyeler,?Nicole it should be Beyeler only. I tried this one:

SELECT SUBSTRING(NAME FROM 1 FOR POSITION(',' IN NAME)-1) FROM OBJ_RESOURCE

Answer 1

You can nest functions:

SUBSTRING(REPLACE(name, '*Deleted*', '' ) FROM 1 FOR POSITION(',' IN REPLACE(name, '*Deleted*', '' ))-1) FROM OBJ_R