mysql - 如何在一个 SQL 语句中使用 Substring 和 Replace？

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

而不是 Deleted Beyeler, Nicole 它应该只是 Beyeler。我试过这个：

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

标签： mysqlsqlreplacesubstring

Answer 1

您可以嵌套函数：

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