SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
create table db (HdrSubject text); insert into db values ('ref:TKjQ9O+2YfTAXlUJMch0FT:ref '); select LTRIM(RTRIM(SUBSTRING( /* <text>> */HdrSubject, /* <start > */CHARINDEX(':',HdrSubject,1) + 1, /* <length> */CHARINDEX(':', SUBSTRING(HdrSubject, CHARINDEX(':', HdrSubject, 1) + 1, 99)) - 1 FROM db
Stuck with a problem? Got Error? Ask ChatGPT!
Copy Clear