mirror of
https://github.com/ivuorinen/cheatsheet-tldr.git
synced 2026-01-26 11:33:59 +00:00
30 lines
982 B
Plaintext
30 lines
982 B
Plaintext
---
|
|
syntax: markdown
|
|
tags: [tldr, common]
|
|
source: https://github.com/tldr-pages/tldr.git
|
|
---
|
|
# fselect
|
|
|
|
> Find files with SQL-like queries.
|
|
> More information: <https://github.com/jhspetersson/fselect/blob/master/docs/usage.md>.
|
|
|
|
- Select full path and size from temporary or configuration files in a given directory:
|
|
|
|
`fselect size, path from {{path/to/directory}} where name = '{{*.cfg}}' or name = '{{*.tmp}}'`
|
|
|
|
- Find square images:
|
|
|
|
`fselect path from {{path/to/directory}} where width = height`
|
|
|
|
- Find old-school rap 320kbps MP3 files:
|
|
|
|
`fselect path from {{path/to/directory}} where genre = {{Rap}} and bitrate = {{320}} and mp3_year lt {{2000}}`
|
|
|
|
- Select only the first 5 results and output as JSON:
|
|
|
|
`fselect size, path from {{path/to/directory}} limit {{5}} into json`
|
|
|
|
- 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}}"`
|