How To Select Rows in MySQL with No Matching Entry in Another Table

Author: , May 16th, 2018

SELECT t1.id FROM tableOne t1 LEFT JOIN tableTwo t2 ON t1.id = t2.id WHERE t2.id IS NULL The “WHERE t2.id IS NULL clause” restricts the results to only those rows where the id returned from tableTwo is null. tableTwo.id will be NULL for all records from tableOne where the id is not found in tableTwo.

How To Select the Max Numeric in a Varchar Column in MySQL

Author: , October 2nd, 2015

I needed to automate the addition of new users with a sequential member’s ID in WordPress. Additionally, there were non-numeric entries in that column that had to be ignored. The wp_users.user_login column is a varchar(60) and so does not naturally handle numeric operations well at all. The solution is a combination of REGEXP and cast(): […]

How To Select the First Table Cell in the First Row Using CSS

Author: , April 19th, 2014

table.myTable > tbody > tr:first-child > td:first-child

How To Select Only Numeric Values From MySQL

Author: , September 6th, 2012

How To Check If Any Radio Button In A Group Is Checked Using jQuery

Author: , May 9th, 2012

How To Display Rows From MySQL Using PHP And Smarty v2

Author: , January 27th, 2012

The PHP

The Smarty Template

How To Deselect All Options Using jQuery

Author: , July 2nd, 2011

How To Select The First Option Using jQuery

Author: , July 2nd, 2011

How To Copy Data From Table To Table Using MySQL

Author: , June 8th, 2011

How To Select A jQuery UI Tab From A Link Anchor

Author: , May 11th, 2011

The HTML:

The jQuery: