有没有办法找到最后一个子串? [英] Is there a way to find a last substring?

问题描述

我的大脑可能真的很累，但我似乎无法解决这个简单的查询.我想从列中提取分隔符(如，")中的最后一个子字符串?我正在考虑使用 REVERSE 或 RIGHT ......但结果真的很奇怪......

my brain might be really tired but i coudn't seem to work my head around this simple query.. I want to extract a last substring within delimiters such as ',' from a column? i was thinking about using REVERSE or RIGHT.. but the results are coming off as really bizarre...

假设我在表 LOANS 中有一个表列DESCRIPTION"，其中包含一个条目

Lets say i have a table column 'DESCRIPTION' in a table LOANS with an entry

Changed Loan Laptop from "IT-X130E-10" to "IT-X130E-9".

我想要最后一个子串

IT-X130E-9

在分隔符 '"' 内希望现在更清楚

within delimiters '"' hope its clearer now

推荐答案

可以试试 SUBSTRING INDEX(str,delim,count)

SELECT SUBSTRING_INDEX(
    SUBSTRING_INDEX('yourString', '"', -2), '"', 1);

这篇关于有没有办法找到最后一个子串?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！