Select values inside parenthesis using sql

[clye]

Hi, I have columnn in my table that has the following values

SPRSTART::  (IMEI: AT+CGSN    8888XXX OK  );  (SC: YFS02);  (Date: Oct  4 2022);  (Time: 3:32:28 PM);  
SPREND::  (IMEI: AT+CGSN    8888XXX OK  );  (SC: YFS02);  (Date: Oct  4 2022);  (Time: 3:32:39 PM);  (AvgFlow: 26.76);  (Liters: 0.45);  

How can i select the values inside the parenthesis and will display below table

START 8888XXX YFS02 SENSOR #2  Oct  4 2022	3:32:28 PM	NULL	       NULL    NULL
END  8888XXX  YFS02 SENSOR #2  Oct  4 2022  NULL        3:32:39 PM     26.76   0.45

Thanks in advance! Im using waterflowsensor here, and i want to display the data in database when it started and ended

[J-M-L]

it's an arduino forum here, not an SQL forum...
you did not mention which database you are using

• MySQL : SUBSTR() or SUBSTRING()
• PostgreSQL : SUBSTR() or SUBSTRING()
• Oracle : SUBSTR() or SUBSTRING()
• SQL Server : SUBSTRING()
• SQLite : SUBSTR()
• Firebird : SUBSTRING()
  ...