Search code examples
mysqlmysql-json

Select value for a key in json in specific column in MySQL

In MySQL, how do I select ONLY the values for nationality key in the jsonInfo column for all rows?

userid  displayName jsonInfo
11  John Nakamura   {"nationality":"ROK", "build": "average", "height":"511", "eyeColor":"brown", "ethnicity":"Asian"}
12  Jose Hernandez  {"nationality": "El Salvador", "build": "average", "height":"510", "eyeColor":"brown", "ethnicity":"Latino"}
13  Bobby Simmons   {"nationality": "USA", "build": "big", "height":"601", "eyeColor":"blue", "ethnicity":"Caucasian"}
Solution 
  • SELECT jsonInfo->>'$.nationnality' FROM tbl