{"_path":"/knowledge-base/sql-cheatsheet","_draft":false,"_partial":false,"_empty":false,"title":"SQL: Cheatsheet","description":"","excerpt":{"type":"root","children":[{"type":"element","tag":"h1","props":{"id":"sql-cheatsheet"},"children":[{"type":"text","value":"SQL: Cheatsheet"}]},{"type":"element","tag":"h2","props":{"id":"replace-strings"},"children":[{"type":"text","value":"Replace strings"}]},{"type":"element","tag":"p","props":{},"children":[{"type":"text","value":"Example: Replace "},{"type":"element","tag":"em","props":{},"children":[{"type":"element","tag":"strong","props":{},"children":[{"type":"text","value":".JPG"}]}]},{"type":"text","value":" with "},{"type":"element","tag":"em","props":{},"children":[{"type":"element","tag":"strong","props":{},"children":[{"type":"text","value":".jpg"}]}]},{"type":"text","value":" in the "},{"type":"element","tag":"em","props":{},"children":[{"type":"element","tag":"strong","props":{},"children":[{"type":"text","value":"media"}]}]},{"type":"text","value":" table:"}]},{"type":"element","tag":"code","props":{"code":"UPDATE media SET file_name = REPLACE(file_name, '.JPG','.jpg');\n"},"children":[{"type":"element","tag":"pre","props":{},"children":[{"type":"element","tag":"code","props":{"__ignoreMap":""},"children":[{"type":"text","value":"UPDATE media SET file_name = REPLACE(file_name, '.JPG','.jpg');\n"}]}]}]}]},"public":true,"body":{"type":"root","children":[{"type":"element","tag":"h1","props":{"id":"sql-cheatsheet"},"children":[{"type":"text","value":"SQL: Cheatsheet"}]},{"type":"element","tag":"h2","props":{"id":"replace-strings"},"children":[{"type":"text","value":"Replace strings"}]},{"type":"element","tag":"p","props":{},"children":[{"type":"text","value":"Example: Replace "},{"type":"element","tag":"em","props":{},"children":[{"type":"element","tag":"strong","props":{},"children":[{"type":"text","value":".JPG"}]}]},{"type":"text","value":" with "},{"type":"element","tag":"em","props":{},"children":[{"type":"element","tag":"strong","props":{},"children":[{"type":"text","value":".jpg"}]}]},{"type":"text","value":" in the "},{"type":"element","tag":"em","props":{},"children":[{"type":"element","tag":"strong","props":{},"children":[{"type":"text","value":"media"}]}]},{"type":"text","value":" table:"}]},{"type":"element","tag":"code","props":{"code":"UPDATE media SET file_name = REPLACE(file_name, '.JPG','.jpg');\n"},"children":[{"type":"element","tag":"pre","props":{},"children":[{"type":"element","tag":"code","props":{"__ignoreMap":""},"children":[{"type":"element","tag":"span","props":{"class":"line"},"children":[{"type":"element","tag":"span","props":{"style":{}},"children":[{"type":"text","value":"UPDATE media SET file_name = REPLACE(file_name, '.JPG','.jpg');"}]}]}]}]}]}],"toc":{"title":"","searchDepth":2,"depth":2,"links":[{"id":"replace-strings","depth":2,"text":"Replace strings"}]}},"_type":"markdown","_id":"content:04.knowledge-base:sql-cheatsheet.md","_source":"content","_file":"04.knowledge-base/sql-cheatsheet.md","_extension":"md"}