Find words form same column in Database (Search)

where_in doesn't work because it is looking for an exact match to the array values. It means select titles that are in this array, not titles that have some bits found in this array.

So I am actually surprised you got any results at all. Unless the rest of your query gave you a result, you should have had a null result from that, since none of your titles are in that array you used as an example.

pdthinh gave the right way to do it.

The way to do what you are trying to do is with the like and or_like statements, with a loop through your search terms. So use the loop from pdthinh's solution and the groups from his later solution and that will do it.

Best wishes,

Paul.