ID3SQL.exe [-f|--fileRegex FILEREGEX] [-d|--directory DIRECTORY] [-v|--verbose] [-r|--recycle] [-y|--dryRun] [-s|--stringLiteralSeparator STRINGLITERALSEPARATOR] [-l|--ignoreCaseRegex] [-c|--columnNames] [-l|--columnSeparator COLUMNSEPARATOR] SQLSTATEMENT
ID3SQL.exe [-h|--help]

  -f, --fileRegex                 .NET-style Regex to determine whether file is to be evaluated. Evaluates the whole file path. Defaults to /.*\.(wma|mp3|m4a)/

  -d, --directory                 Directory to recursively search for tag files. Defaults to current users "My Music" directory

  -v, --verbose                   (Default: False) Prints more information to STDOUT as the process runs

  -r, --recycle                   (Default: False) When running DELETE statements, determine whether to fully delete files or just put them in Windows Recycle Bin

  -y, --dryRun                    (Default: False) When running UPDATE or DELETE statements, flags whether to actually make changes to the files. If true, no changes will be made, but they will log via the verbose (-v, --verbose) flag as if they were actually updated/deleted

  -s, --stringLiteralSeparator    (Default: ;) When comparing a string against a string array, sets the delimiter to use to split the string

  -l, --ignoreCaseRegex           (Default: True) Sets whether the where-clause "LIKE" regex should ignore case

  -c, --columnNames             (Default: True) When running SELECT statements, flags whether to print the column names as the first line

  -l, --columnSeparator         (Default:     |       ) When running SELECT statements, the string given here will be the glue between each column. Usually a variation of the pipe-character

  --help                          Display the help screen.

SELECT *

SELECT * WHERE Album = 'Hotel California'

SELECT Album, FirstAlbumArtist WHERE 'Gorillaz' IN AlbumArtists

DELETE

DELETE WHERE Year = 1995

UPDATE SET Disc = 1, DiscCount = 2

UPDATE SET Genres = 'Rap;Gangsta Rap' WHERE Lyrics LIKE '.* rhythm .*' AND Year >= 2000

ID3SQL.exe -s "&" "UPDATE SET Genres = 'Rap&Gangsta Rap' WHERE Lyrics LIKE '.* rhythm .*' AND Year >= 2000"