I simply wish to add json information kind in put up meta subject as like in regular database.
json information can be within the construction under,
Put up Title Meta Knowledge
1.Pattern title 1 ---> {title:Austin,rating:40},
{title:Rock,rating:60},
{title:Vinci,rating:48}
2.Pattern title 2 ---> {title:Steve,rating:25},
{title:Ricky,rating:90}
3.Pattern title 3 ---> {title:Bichel,rating:10},
{title:Ronaldo,rating:78},
{title:Mathew,rating:80}
The outcome What I wanted is
Pattern title 2 Winner title Ricky and rating is 90 // since 90 is highest amongst all of the three posts
Pattern title 3 Winner title Mathew and rating is 80
Pattern title 1 Winner title is Rock and rating is 60
Test the above instance
The put up no.1 have 3 usernames and three scores, equally put up no 2, 3.. have identical kind of usernames and scores. I want to type (meta information) rating orderby highest rating then get posts so the outcome can be
Put up Title Meta Knowledge
1.Pattern title 1 ---> {title:Rock,rating:60},
{title:Vinci,rating:48},
{title:Austin,rating:40}
2.Pattern title 2 ---> {title:Ricky,rating:90},
{title:Steve,rating:25}
3.Pattern title 3 ---> {title:Mathew,rating:80},
{title:Ronaldo,rating:78},
{title:Bichel,rating:10}
once more I’ll fetch all of the put up and type the posts in line with
beforehand sorted highest rating. If it’s a tedious question, Not less than I want to take first index of each postmeta’s rating and order the posts by highest rating.
What I’ve already carried out is saved this json as array in put up meta. Get all of the put up ($paged= -1) and corresponding postmeta then type postmeta from php facet and order the posts. however so long as it’s small db it might probably deal with this load. However this db could go as massive as 50k posts.
So I want to transfer to another implementation. Identical to regular DB
with JSON information kind orderby is it doable?, If not counsel me a
resolution for it.