I need a trigger on below condition,
am having a table called "Tracker", msg_text is a column in the tracker table.
msg_text contains data like : "NAme <R> city <R> pin <R> phone <R> email <R> country <R>"
<R> Specified the seperator.
my requirement is when a user enters records into tracker table - msg_text column
in above format, data should be enter into another table
"Address" it contains column names "NAme | city | pin | phone | email | country |
Please help me....