'Select a specific part of a value from a column in mariadb

i´m new in SQL and want to solve following case.

I have a table in a MariaDB named inventories. In this table are 2 columns: identifier and data. I want to select and output a specific part in the column data, if the identifier is a specific one.

For example:

identifier	data
steam:xxxxxxxxxxxxxxx	...some data...,"Serial":"ZF3CJ8L1rrKjwP7nKTzb",...some more data...

The only part, that i want in the output is this: "Serial":"ZF3CJ8L1rrKjwP7nKTzb" but the part behind "Serial":" is a random value.

How can i solve this?

(i put a screenshot in here, table does not work for me in editorscreenshot of table in stackoverflow editor.)

mysql sql mariadb

Solution 1:^[1]

You can try using the SubString function, which only returns a certain amount of character and starts a whatever character you want.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	Elliot

'Select a specific part of a value from a column in mariadb

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]