Home > Blockchain >  How to find specific string and dynamic string
How to find specific string and dynamic string

Time:11-02

How can I get the values in single quote from DescriptionMsg column which having the common string as 'Account Number is changed from'.

SELECT Logid, mrd_id, mrd_accountnumber, DescriptionMsg
FROM RecordData_Log
WHERE Log_date > '2020-12-31 23:59:59.999'
AND Log_type = 'Record Updated'
AND DescriptionMsg LIKE '           
  • Related