I am having my data in a table mysql. The fields are
sender,receiver,sent
the format of sender field is
sender-xyz abc
I am having a text file ld1.txt in the format
uid : department : branch
xyz.abc : xxx : yyy
I want to write a script which will compare the mysql
sender fields part ie after < sign and before @ sign
ie xyz.abc with text file and if found then print the
report in following format: