mysql_queries.sql

# Create a CSV with query results and save it to a file
SELECT * FROM table INTO OUTFILE '/var/lib/mysql-files/table.csv' FIELDS ENCLOSED BY '"' TERMINATED BY ',' ESCAPED BY '"' LINES TERMINATED BY '\r\n';

# Get selected fields and include a related field from other table
SELECT tableA.filed1, tableA.field2, tableB.filed1, tableB.field2 FROM tableA INNER JOIN tableB ON tableA.id = tableB.id;

# Filter fields with wildcard and order by a cetain field
SELECT * FROM table WHERE field1 LIKE '%@example.com' ORDER BY field2

# Find unique duplicated records of a certain field
SELECT * FROM table GROUP BY field HAVING COUNT(*) >= 2;

# Find duplicated records of a certain field
SELECT field1, field2, table.field3 FROM table INNER JOIN (SELECT field3 FROM table GROUP BY field3 HAVING COUNT(*) > 1) dup ON table.field3 = dup.field3;