how to order mysql result based on the json key of a json object stored in a column

Question

jSonColoumn - data type (TEXT)

sample rows

{"scheduledTime":"2014-01-29 19:55:00"}  
{"scheduledTime":"2014-01-29 22:55:00"}    
{"scheduledTime":"2014-01-29 15:55:00"}
{"scheduledTime":"2014-01-29 08:55:00"}

i need to sort this result with the "scheduledTime" key of the json object stored in the column "jSonColoumn". (Simply i need to order by the result based on the "scheduledTime" key of the json)

Thanks

its that realy sql? from what sql does this data come? did u try order by ? please improve your question — Melon
– Melon, Commented Jan 29, 2014 at 14:52

Patrick Hofman · Accepted Answer · 2014-01-29 15:07:23Z

2

There are some MySQL JSON functions.

Like this:

select json_extract(columnX, '{"scheduledTime"}')

edited Jan 29, 2014 at 15:07

answered Jan 29, 2014 at 14:54

Patrick Hofman

158k23 gold badges270 silver badges343 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Lauris Kuznecovs Over a year ago

select json_extract(columnX, '$.scheduledTime')

Collectives™ on Stack Overflow

how to order mysql result based on the json key of a json object stored in a column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related