{"repo":"laktak/zfind","free":true,"listed":false,"github":"https://github.com/laktak/zfind","clone":"git clone https://github.com/laktak/zfind.git","description":"search for files (even inside tar/zip/7z/rar) using a SQL-WHERE filter","language":"Go","stars":410,"topics":["cli","find","sql"],"license":"MIT","category":"databases-storage","readme_excerpt":"zfind { repos & mirrors: github.com/laktak/zfind, codeberg.org/laktak/zfind } zfind allows you to search for files, including inside tar , zip , 7z and rar archives. It makes finding files easy with a filter syntax that is similar to an SQL-WHERE clause. This means, if you know SQL, you don't have to learn or remember any new syntax just for this tool. - Basic Usage & Examples - Where Syntax - Properties - Supported archives - Actions - Configuration - Installation - Install/Update Binaries - Homebrew (macOS and Linux) - Arch Linux - Build from Source - zfind as a Go module Basic Usage & Examples Examples Where Syntax - AND , OR and () parentheses are logical operators used to combine multiple conditions. AND means that both conditions must be true for a row to be included in the results. OR means that if either condition is true, the row will be included. Parentheses are used to group conditions, just like in mathematics. Example: '(size 20M OR name = \"temp\") AND type=\"file\"' selects all files that are either greater than 20 MB in size or are named temp. - Operators = , < , != , , = are comparison operators used to compare values and file properties. The types must match, meaning don't compare a date to a file size. Example: 'date \"2020-10-01\"' selects all files that were modified after the specified date. - LIKE , ILIKE and RLIKE are used for pattern matching in strings. - LIKE is case-sensitive, while ILIKE is case-insensitive. - The % symbol is used as a wildcard characte","default_branch":null,"files":null,"tree":[],"storefront":"/r/laktak","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/laktak/zfind/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}