I want to display only the specific user details as shown in link. For kind information, I just want to say that I am using php and mysql and need to display 'user2' details from that previous table(customer) given as picture link].help with valuable suggestion.
Try this
SELECT id,rcvusr FROM xyz WHERE rcvusr like 'user2%' ORDER BY eid desc LIMIT 10
Select id, sndusr, SUBSTRING_INDEX(rcvusr, '@@', 1), title
From xyz
Where rcvusr = 'user2' or
rcvusr like 'user2@@%'
Here is the documentation : http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_substring-index