SET @TEST_STR='xxx: yyy, datetime: 2016-03-25 22:22:16 +0900'; select STR_TO_DATE(SUBSTR(@TEST_STR, INSTR(@TEST_STR, 'datetime') + 10, 25), '%Y-%m-%d %H:%i:%s'); +----------------------------------------------------------------------------…