Earlier today a client requested I change the output of their lead form to split the “full name” entry into “first name” and “last name”. My initial thought was to use a Regular Expression (RegExp) to match the parts of the string for my UPDATE query…
I looked around on the web for a while trying to find an example of what I was trying to do. Some were close, but none performed the JOIN portion of the query and on the same table from the SELECT portion (self referencing). So, here is the code I used to created a sub-category only dropdown using the parent categories as the optgroup labels.
The following code is how you would mass-update a single field in a MySQL table with a string prepended and appended to the field’s existing value.