Change paths of files in MIXXX sqlite dabatase

update_mixxx_paths.sql

/**
 *Looks for directory *750GB* in the path and removes it for paths.
 * Based on that you can do any replacements.
 */

UPDATE track_locations
SET location = replace (location, '750GB/', '')
where
location LIKE '%750G%';

UPDATE track_locations
SET directory = replace (directory, '750GB/', '')
where
directory LIKE '%750G%';

UPDATE directories
SET directory = replace (directory, '750GB/', '')
where
directory LIKE '%750G%';