title: SQL query to change file extension in a record containing a file-path?
body: <p>Given an SQL table <code>Table</code> with a column <code>path</code>, how can I modify values like <code>/dir/subdir/file.aaa</code> => <code>/dir/subdir/file.bbb</code> e.g. modify just the file-extension without having to hard-code the specific file/path into my query?</p>