Showing entries 1 to 1
Displaying posts with tag: TRAILING (reset)
Find/parse a string from within a string

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` (
  `urldemo` varchar(150) NOT NULL,
  PRIMARY KEY (`id`)
| id | urldemo                    |
|  1 |      |
|  2 | …

[Read more]
Showing entries 1 to 1