Aug 01 Love0 WordPress SQL Syntax Example By Prodjex SQL, Wordpress No Comments I have a couple of tables I'm joining and only want to return users that a field missing in the joined table. Users id fname lname userMeta id metaKey metaValue…Read More
Jul 31 Love0 Delete Duplicates from mySQL Database Table By Prodjex mySQL, SQL No Comments I was trying to figure out a query to count the IP addresses I had in a table, tell me how many are the same, then delete duplicates only leaving…Read More
Jul 31 Love0 SQL Case Statement Example By Prodjex SQL No Comments Basic syntax for using case when statements in SQL. For this example we want the following: If Field1 = 2 and Field2 = 2 then use the date in Field3…Read More