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

Reply via email to