Show specific data from MySQL / MariaDB table

Joshhh

Member
Apr 13, 2016
296
157
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);
JSON:
{"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
 

Wickd

The first member of the Knights of the Pink Table
Jan 15, 2013
1,931
605
What do you mean posts?Are you tryin' to do a read on your web app?
 

Users who are viewing this thread

Top