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 |
+------------------------------+