Or to make it more explanatory for the non experts or newbies: SELECT jsonval->'base', jsonval->'hash', jsonval->'wiki' FROM config WHERE name=lower($name)
Or to make it more explanatory for the non experts or newbies: SELECT jsonval->'base', jsonval->'hash', jsonval->'wiki' FROM config WHERE name=lower($name)