两个字符串之间的 MySQL 子字符串

2021-12-21 00:00:00 function indexing string mysql substring

我需要帮助解决我的列字段的问题.我需要在这两个不同的字符串模式"之间提取字符串，例如:

I need a hand to solve a problem with my column field. I need to extract the string in between these two different "patterns" of strings for example:

[...string] 合约 = 1234567890123350566076070666 发出 = [string]...]

[...string] contract= 1234567890123350566076070666 issued= [string ...]

我想提取 'contract=' 和 'issued=' 之间的字符串

I want to extract the string in between 'contract=' and 'issued='

目前我正在使用

SELECT substring(substring_index(licence_key,'contract=',-1),1,40) FROM table

问题是中间的这个字符串并不总是有 40 个字符，所以它不是固定长度，所以它之前和之后的数据.这是一个不稳定的数据.

The problem is that this string in between doesn't have always 40 characters so it's not fixed length and so the data that comes before and after that. It's a volatile data.

你知道我怎么处理吗?

推荐答案

只需使用 substring_index() 两次:

SELECT substring_index(substring_index(licence_key, 'contract=', -1),
                       'issued=', 1)
FROM table;

相关文章