I have a keyword search through articles on my website. If the user enters multiple keywords, what is the best way to search through the database? Should I seperate the keywords into two seperate searches?
Right now I'm using something like this:
$query = "select * from articles where content like '%".$string."%'";
But this obviously fails when the user enters multiple keywords.
Thanks!