Search Results for: mysql 8

Converting comma separated fields to MySQL JSON – a case study

This post is a case study of a job I had to do in a legacy application, it doesn’t mean it will apply to you, but it might. This is a table of contents: Performance Searching Converting to a JSON array 1st step: remove the leading commas 2nd step: add brackets to the string 3rd … Continue reading Converting comma separated fields to MySQL JSON – a case study