Show specific data from MySQL / MariaDB table

[Joshhh]

Hi,

So I'm a bit stuck with a MySQL query. Basically, I want to have something that posts the data from the 'job' column in my database. However in this column it generates all of the information as JSON. (This is what it looks like in the table);

{"onduty":true,"payment":10,"label":"Civilian",

However, seeing as it's in the JSON format, I can't just do the generic query as it'll just post the whole format.

How do I go about just selecting the data that's in the quotation marks after the 'Label', in this case; "Civilian".

Thanks

 

[CosmoPeak]

You can use json_extract -

You must be registered for see links

eg. SELECT json_extract(json_col, '$.label') as label

 

[Wickd]

What do you mean posts?Are you tryin' to do a read on your web app?

 

[Markshall]

You can use json_extract -

You must be registered for see links

eg. SELECT json_extract(json_col, '$.label') as label

Well I had absolutely no idea that existed LOL. Damn. Thanks for that.