MySQL – Select First 2 Characters In Field Using Matching Pattern

MySQL – Select First 2 Characters In Field Using Matching Pattern

ByReid Walley

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…

MySQL – Change 1,000 Joomla User Receive System Emails To No

ByReid Walley

Problem: Client had accidentally set all User’s Receive System Emails to YES. Receive System Emails are for Super Users/Webmaster only – not for 1,000 members. Solution: Use phpMyAdmin to select and confirm that all 1,000 Joomla Users whose Receive System Emails are set to sendMail=1 (1=Yes) SELECT * FROM `xxxx_users` WHERE sendemail=1 Then, update all Receive System Emails from…