I have a simple MySQL database keyword search that is functional. However results for the search are not being returned if the keywords are not in the same order as entered in the database.
For example searching for "dog cat mouse" will return a result, becuase this is the order that it is written in the database but searching for "dog mouse cat" will return no results. Here is my code.
$sql = "SELECT * FROM table WHERE title LIKE '%$q%' OR date LIKE '%$q%' OR keywords LIKE '%$q%' ORDER BY date";
Any help on how to fix this issue would be greatly appreciated.
James