Question: This is my current query

```
WHERE Keywords.Word = '$search'

```

But this only works if `$search` is one word, if its two or three words then it won't find anything as my keywords table words field only has one word per record.

Whats the quickest way to do this ?

Answer: 
Depends on your programming language, split the search term into an array, and use the `IN` clause :

```
WHERE Keywords.Word IN ('$search[0]','$search[1]',...)

```
`IN` clause will not give you the best performance. You can look at [my answer on this other question](https://stackoverflow.com/questions/5295738/mysql-query-selecting-a-certain-array-of-results/5295852#5295852).