-- Convert any existing plain-text messages to JSON objects {"text": "..."} UPDATE order_messages SET message = JSON_OBJECT('text', message) WHERE message NOT LIKE '{%';