This problem seems almost designed for regexp_replace() : select regexp_replace(tag, '(.*)_[^_]*$', '1') from football;.
確定! 回上一頁