parse results in MySQL via REGEX
- by Derek Adair
Hi,
I'm a bit confused on the functionality of the REGEX support for MySQL and I have yet to find a solid example on how to separate a result with REGEX within an sql statement.
Example:
How could I pull data from a table emails that looks something like...
+-------------------------+
|Emails |
|-------------------------|
|[email protected]|
+-------------------------+
and return something through an sql statement that looks like...
+------------------------------+
|Username | Domain | TLD |
|-----------|------------|-----|
|some.email | yourdomain | com |
+------------------------------+