Select

• jq '.[] | select(.color=="blue")' your_json_file.json
• select * from TABLE_NAME (SQL)

• select current_setting('block_size');

• MySQL: select user FROM mysql.user;

Related terms

• MongoDB: db.YOUR_COLLETION_NAME.find ()
• select count

See also

• SQL, NewSQL, RDMS: GraphQL (2015), SQLite, select, insert, select count, Distributed SQL, TablePlus, Cache hit ratio, pg_stat_user_tables, EXPLAIN, Index (PostgreSQL), DDL, SQL/MED, Group by, List users, SQL Injection, SQLAlchemy, CREATE USER, CREATE ROLE, EXPLAIN, ALTER DATABASE, REVOKE, NOLOCK, NOWAIT, EXISTS, Unique constraint, .sql