SQL Query Builder

SELECT is the fundamental SQL statement for retrieving data from databases. It specifies which columns to fetch, which table to query, optional conditions for filtering rows (WHERE), sorting (ORDER BY), and result limiting (LIMIT). This tool generates standard SELECT queries that work with MySQL, PostgreSQL, SQLite, and other relational databases.

Enter the table name you want to query. Select which columns to include in your results (or select multiple). Add WHERE conditions to filter rows: choose a column, an operator (=, !=, >, <, LIKE, IN, IS NULL), and a value. Add multiple conditions which are combined with AND. Optionally specify ORDER BY column and sort direction, and LIMIT to restrict the number of results. Click Generate Query to build your SQL statement, then Copy to use it.

Equality: = matches exact values, != excludes values. Comparison: > (greater than), >= (greater or equal), < (less than), <= (less or equal). Pattern matching: LIKE matches patterns (use % for wildcards). Set membership: IN checks if value exists in a list. Null checks: IS NULL / IS NOT NULL test for absent values. These operators let you precisely filter database results.