MySQL – Select First 2 Characters In Field Using Matching Pattern
Problem: After running Easy Profile on Joomla to split up Joomla’s standard First-Name-and-Last-Name-all-on-one-line into separate First Name and Last Name fields, a bunch of User’s middle initials (eg: L.) are now at the beginning of the Last Name field. Here’s an example: Joomla’s standard signup only provides one field to enter a user’s name: John…