back to context overview

fselect

List of commands for fselect:

- fselect
fselect:tldr:29d8e fselect: Find old-school rap 320kbps MP3 files.

$ fselect path from ${path-to-directory} where genre = ${Rap} and bitrate = ${320} and mp3_year lt ${2000}

try on your machine

explain this command
- fselect
fselect:tldr:2b4dd fselect: Find square images.

$ fselect path from ${path-to-directory} where width = height

try on your machine

explain this command
- fselect
fselect:tldr:32bc1 fselect: Use SQL aggregate functions to calculate minimum, maximum and average size of files in a directory.

$ fselect "${MIN(size), MAX(size), AVG(size), SUM(size), COUNT(*)} from ${path-to-directory}"

try on your machine

explain this command
- fselect
fselect:tldr:9a4f8 fselect: Select full path and size from temporary or config files in a given directory.

$ fselect size, path from ${path-to-directory} where name = ${'*-cfg'} or name = ${'*-tmp'}

try on your machine

explain this command
- fselect
fselect:tldr:be6e0 fselect: Select only the first 5 results and output as JSON.

$ fselect size, path from ${path-to-directory} limit ${5} into json

try on your machine

explain this command

back to context overview