# fselect - SQL Query 로 하드에서 파일 찾기 > Clean Markdown view of GeekNews topic #525. Use the original source for factual precision when an external source URL is present. ## Metadata - GeekNews HTML: [https://news.hada.io/topic?id=525](https://news.hada.io/topic?id=525) - GeekNews Markdown: [https://news.hada.io/topic/525.md](https://news.hada.io/topic/525.md) - Type: news - Author: [xguru](https://news.hada.io/@xguru) - Published: 2019-09-15T09:29:29+09:00 - Updated: 2019-09-15T09:29:29+09:00 - Original source: [cli.fan](https://cli.fan/posts/fselect/) - Points: 4 - Comments: 1 ## Topic Body fselect path, size from /usr where size > 10M order by size desc limit 10 파일 시스템에 있는 정보 컬럼부터 exif 및 mp3 tag 정보까지 다양하게 사용가능 SUM,LENGTH,COUNT,AVG,YEAR,MIN,MAX 등 함수도 지원 name, path, abspath, size, fsize, uid, gid, accessed, created, modified, mode, user, group, sha1, sha256, sha512 등의 컬럼 ## Comments ### Comment 427 - Author: xguru - Created: 2019-09-15T09:32:45+09:00 - Points: 1 지원하는 필드 리스트 이미지의 width,height mp3 의 title,artist,album 등 태그 exif 의 lat,lon,model 등 find 보다 훨씬 유용하게 사용가능 https://github.com/jhspetersson/fselect/blob/0.6.5/src/field.rs#L89 "name" => Ok(Field::Name), "path" => Ok(Field::Path), "abspath" => Ok(Field::AbsPath), "size" => Ok(Field::Size), "fsize" | "hsize" => Ok(Field::FormattedSize), "uid" => Ok(Field::Uid), "gid" => Ok(Field::Gid), "user" => Ok(Field::User), "group" => Ok(Field::Group), "created" => Ok(Field::Created), "accessed" => Ok(Field::Accessed), "modified" => Ok(Field::Modified), "is_dir" => Ok(Field::IsDir), "is_file" => Ok(Field::IsFile), "is_symlink" => Ok(Field::IsSymlink), "is_pipe" | "is_fifo" => Ok(Field::IsPipe), "is_char" | "is_character" => Ok(Field::IsCharacterDevice), "is_block" => Ok(Field::IsBlockDevice), "is_socket" => Ok(Field::IsSocket), "mode" => Ok(Field::Mode), "user_read" => Ok(Field::UserRead), "user_write" => Ok(Field::UserWrite), "user_exec" => Ok(Field::UserExec), "user_all" | "user_rwx" => Ok(Field::UserAll), "group_read" => Ok(Field::GroupRead), "group_write" => Ok(Field::GroupWrite), "group_exec" => Ok(Field::GroupExec), "group_all" | "group_rwx" => Ok(Field::GroupAll), "other_read" => Ok(Field::OtherRead), "other_write" => Ok(Field::OtherWrite), "other_exec" => Ok(Field::OtherExec), "other_all" | "other_rwx" => Ok(Field::OtherAll), "suid" => Ok(Field::Suid), "sgid" => Ok(Field::Sgid), "is_hidden" => Ok(Field::IsHidden), "has_xattrs" => Ok(Field::HasXattrs), "is_shebang" => Ok(Field::IsShebang), "width" => Ok(Field::Width), "height" => Ok(Field::Height), "mime" => Ok(Field::Mime), "line_count" => Ok(Field::LineCount), "duration" => Ok(Field::Duration), "mp3_bitrate" | "bitrate" => Ok(Field::Bitrate), "mp3_freq" | "freq" => Ok(Field::Freq), "mp3_title" | "title" => Ok(Field::Title), "mp3_artist" | "artist" => Ok(Field::Artist), "mp3_album" | "album" => Ok(Field::Album), "mp3_year" => Ok(Field::Year), "mp3_genre" | "genre" => Ok(Field::Genre), "exif_altitude" | "exif_alt" => Ok(Field::ExifGpsAltitude), "exif_datetime" => Ok(Field::ExifDateTime), "exif_latitude" | "exif_lat" => Ok(Field::ExifGpsLatitude), "exif_longitude" | "exif_lon" | "exif_lng" => Ok(Field::ExifGpsLongitude), "exif_make" => Ok(Field::ExifMake), "exif_model" => Ok(Field::ExifModel), "exif_software" => Ok(Field::ExifSoftware), "exif_version" => Ok(Field::ExifVersion), "is_binary" => Ok(Field::IsBinary), "is_text" => Ok(Field::IsText), "is_archive" => Ok(Field::IsArchive), "is_audio" => Ok(Field::IsAudio), "is_book" => Ok(Field::IsBook), "is_doc" => Ok(Field::IsDoc), "is_image" => Ok(Field::IsImage), "is_source" => Ok(Field::IsSource), "is_video" => Ok(Field::IsVideo), "sha1" => Ok(Field::Sha1), "sha2_256" | "sha256" => Ok(Field::Sha256), "sha2_512" | "sha512" => Ok(Field::Sha512), "sha3_512" | "sha3" => Ok(Field::Sha3),