tag:blogger.com,1999:blog-1806101152341830568.post4025437918173113462..comments2022-05-26T23:24:11.283-05:00Comments on Another MySQL DBA: Find/parse a string from within a stringKeith Larson ( anothermysqldba )http://www.blogger.com/profile/10894464761448543094noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1806101152341830568.post-72680190043477860302014-12-29T01:19:46.096-06:002014-12-29T01:19:46.096-06:00Good example, personally i prefer substring_index(...Good example, personally i prefer substring_index()<br /><br />select substring_index(substring_index(urldemo, '/', 3), '/', -1) AS parsed_domain,<br />urldemo as original_url<br />from parse_example;Marcnoreply@blogger.com