Study/ASP.NET MVC & Core2022. 6. 22. 17:47
Study/MySQL2022. 5. 27. 14:37

SELECT uId, charId, dateKey, date, TRIM(BOTH '"' FROM ( json_extract(parameterString, '$.itemId') ))
, TRIM(BOTH '"' FROM ( json_extract(parameterString, '$.amount') ))
, parameterString FROM jsonlog WHERE dateKey = 20220526 and logid = 50701 AND parameterString LIKE '%itemRemoveType":"45"%';

Posted by 굥쓰
Study/Java2022. 5. 25. 18:31