title: mysql json datatype searching for a value inside the array
body: <p>I have a column in a MySQL table that is of json type and the values in that column are a simple 1D array (e.g. [1,2,3,4,5]). How do I use the json_contains function to return all rows that contain the value "5" in the json array?</p>