Sep 19, 2014
Extract data between Brackets MySql
Data Between Angular Brackets
SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"<") + 1), '>', 1)
Data Between Square Brackets
SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"[") + 1), ']', 1)
seen from Moldova
seen from Moldova
seen from Russia
seen from Moldova
seen from United Kingdom
seen from Russia
seen from Russia
seen from United Kingdom
seen from United States
seen from United States
seen from China
seen from Russia
seen from Australia
seen from Norway
seen from United States
seen from United Kingdom
seen from United States
seen from United States
seen from United States
seen from Canada
Extract data between Brackets MySql
Data Between Angular Brackets
SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"<") + 1), '>', 1)
Data Between Square Brackets
SUBSTRING_INDEX(substr(e.dest,instr(e.dest,"[") + 1), ']', 1)