So I noticed a few different questions and posts about parsing a
string out of another string recently. While some solutions
included creating new functions and etc it can also be done
within a single query in some cases.
For example, let us say that we are looking to pull out the
domain from a URL. I will try to go into detail as to why and how
this works.
We have the following table.
CREATE TABLE `parse_example` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`urldemo` varchar(150) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB;
+----+----------------------------+
| id |
urldemo
|
+----+----------------------------+
| 1 | http://www.mysql.com/
|
| 2 | …
Showing entries 1 to 1
Dec
26
2014
Showing entries 1 to 1