Is it possible to pass as array as the input to a SQL query and perform the following?
I have an array of words keywords = ["what","is","your","favorite","color"] I have a column in a mySQL table as follows **keywords** row1=> what:name row2=> what:favorite:color row3=> what:color:like row4=> what:color:hate i need to pass my array in a sql query and get the row with the highest number of similar words in the row and the array. in the above example i should get row3 as the answer. Is it possible? if so, please help me with the code. I am coding in Java