postgresql - 如何在 PostgreSQL 中编写此查询？来自甲骨文的原创

Question

SELECT ACTOR_NAME
FROM MOVIES
WHERE MOVIE_NAME = 'Isle of Dogs'
ORDER BY SUBSTR(ACTOR_NAME, INSTR(ACTOR_NAME, ' ', -1)+1) ASC;

标签： postgresql

Answer 1

我认为您正在寻找的是POSITION命令代替INSTR