mysql - 使用 MYSQL 提取文本列的一部分

Question

我的数据库列包含以下文本 (CLOB)：

Name
Abc corp
Type
Non profit
Main Address
123 Third Street
Cypress CA 90630
Secondary Address
987 Fifth Street
Cypress CA 90630
Date Formed
05/05/2018
Effective Date Formed
05/10/2018
Amendment Date Formed
10/01/2018
Amendment Effective Date
10/03/2018

在 MYSQL 中，我想编写一个拆分这些的查询

Name        Type                Main Address                        Secondary Address                   Date Formed             Effective Date Formed    
---------  ------------         ------------                        ---------------                     -------------           -----------
Abc corp     Non profit         123 Third Street Cypress CA 90630   987 Fifth Street Cypress CA 90630   05/05/2018              05/10/2018

标签： mysql