Hi Here is a mysql query
SELECT * FROM APPL_CORRELATED WHERE MATCH (correlated_rel,details) AGAINST
('sumit');
id application_id correlated_rel details
1 2 sumit cor core corelation
I want to display in which column the keyword “sumit” is found, if it found in
correlated_rel or details.
How can we display the matched column in this Full text search.
Best Regards,
Sumit

