My personal cheatsheet\/reference.<\/p>\n\n\n\n\n\n\n\n
SELECT DISTINCT Album, Artist, Year FROM tableone ORDER BY Artist, Year \n\nSELECT * FROM tablename;\n\nSELECT columnname FROM tablename;\n\nSELECT columnname, columnname FROM tablename;\n\nSELECT * FROM practice WHERE id BETWEEN 120 and 130\n\nSELECT * FROM practice WHERE fieldone = 'Black Sabbath'\n\nSELECT * FROM practice WHERE fieldone LIKE '%Zep%'\n\nSELECT * FROM practice WHERE id < '100'\n\nSELECT * FROM practice WHERE fieldone LIKE 'A____'\n\nSELECT * FROM practice WHERE fieldone LIKE \"Coldplay\" OR fieldone LIKE \"Cream\"\n\nSELECT * FROM practice WHERE fieldone IN ('Coldplay', 'Cream')\n\nSELECT * FROM practice WHERE fieldone NOT IN ('AC-DC', 'Black Sabbath')\n\nSELECT DISTINCT fieldone FROM practice\n\nSELECT * FROM tablename ORDER BY columnname\n\nSELECT * FROM tablename ORDER BY columnname DESC\n\nSELECT * FROM tablename LIMIT 0, 20\n\nSELECT * FROM tablename ORDER BY columnname LIMIT 0, 20\n\nSELECT * FROM tablename ORDER BY columnname DESC LIMIT 0, 20\n\nSELECT COUNT(*) from tablename\n\nSELECT DISTINCT columnname FROM tablename\n\nSELECT fieldone, COUNT(*) FROM practice GROUP BY fieldone\n\nSELECT fieldone, COUNT(*) AS Entries FROM practice GROUP BY fieldone\n\nSELECT fieldone, COUNT(*) AS 'My Fucking Entries' FROM practice GROUP BY fieldone\n\nSELECT fieldone, COUNT(*) AS 'My Entries' FROM practice GROUP BY fieldone ORDER BY 'My Entries'\n\nSELECT fieldone, COUNT(*) AS 'My Entries' FROM practice GROUP BY fieldone ORDER BY 'My Entries' DESC\n\nSELECT DISTINCT Album, Artist, Year FROM tester ORDER BY Album\n\nSELECT DISTINCT Album, COUNT(*) FROM tester GROUP BY Album\n\nSELECT DISTINCT Album, COUNT(*) AS 'Number of Songs' FROM tester GROUP BY Album\n\nSELECT DISTINCT Album, COUNT(*) AS 'Number of Songs', Artist FROM tester GROUP BY Album\n\nSELECT DISTINCT Album, COUNT(*) AS 'Number of Songs', Artist, Year FROM tester GROUP BY Album ORDER BY 'Number of Songs'\n\nSELECT DISTINCT Album, COUNT(*) AS 'Number of Songs', Artist, Year FROM tester GROUP BY Album ORDER BY Artist\n\nSELECT DISTINCT Album, Artist, Year FROM tester GROUP BY Album ORDER BY Artist\n\nSELECT DISTINCT Album, Artist, Year FROM tester ORDER BY Artist \/\/ displays by artist and then albums alphabetically\n\nSELECT DISTINCT Album, Artist, Year FROM tester ORDER BY Artist, Year \/\/ orders first by artist and then by year\n\nSELECT DISTINCT Album, Artist, Year FROM tester \/\/ this easier method does same as above \n\nSELECT * FROM tablename WHERE columnname LIKE '%$tag%'\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"My personal cheatsheet\/reference.<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[50],"tags":[],"class_list":["post-1265","post","type-post","status-publish","format-standard","hentry","category-sql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/posts\/1265","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/comments?post=1265"}],"version-history":[{"count":6,"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/posts\/1265\/revisions"}],"predecessor-version":[{"id":1385,"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/posts\/1265\/revisions\/1385"}],"wp:attachment":[{"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/media?parent=1265"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/categories?post=1265"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/frowningbear.com\/codebase\/wp-json\/wp\/v2\/tags?post=1265"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}