MySQL Regexp Administative Helpers
- Dec 22, 2023
MySQL Regexp Administative Helpers
The MySQL database provides a powerful way to perform complex text-based searches through the regular expressions function REGEXP.
Many websites are operating a MySQL database. Often we create web forms to capture contact information.
Hence some very powerful features are available to help organise that data when we combine Regexp with MySQL.
MySQL Regexp Examples
Task: Find all Customers with Phone Numbers that contain a + or - character in the Home_Ph field.
WHERE Home_Ph REGEXP '[+-]'
If we only wanted to find the numbers with a + symbol-:
WHERE Home_Ph REGEXP '[+]'
Task: If we wanted to find the emails that contain hotmail-:
WHERE Email REGEXP 'hotmail'
Source: How to Use MySQL Regular Expressions
Using the Powerful Features of your Database
We wanted to build a system that better utilised the powerful features of our back-end systems. Why not make the website that collects the data also a powerful CRM tool?
We have the ability to monitor customer behaviour. Nothing sinister or breaches of privacy, just being able to detect which opt in customers are more interested in certain products or services.
Email Marketing from the same system, opens up even more power. Any system that requires duplication of data can be wasteful and inefficient.
Recent Articles
Attention Span Shrinking
- Mar 22 2024
- /
- 228
Understanding UTF-8 For Non-Coders
- Jan 15 2024
- /
- 580
Principles of Interaction Design
- Jan 02 2024
- /
- 781
MySQL Regexp Administative Helpers
- Dec 22 2023
- /
- 828
The Truth About Multitasking
- Sep 27 2023
- /
- 1206
When NOT to pay for SEO
- Sep 05 2023
- /
- 463
Email Marketing vs Social Media Marketing
- Jun 20 2023
- /
- 892
Sugar Through the Ages
- Apr 13 2023
- /
- 770
Managing your domains a quick guide
- Mar 20 2023
- /
- 4111
7 Chakras Compared to Maslow's Hierarchy Of Needs
- Dec 23 2022
- /
- 2
View All News Articles
Categories
A Gold Coast SEO and Web Developer