PHP MYSQL - Search field with spaces
===

This may be something very easy.  I am building a search tool.  I have a varchar field that holds addresses.  Example:

    2343 S Cherry Creek St.

So i want to be able to search part or all of the field.  I have tried

    LIKE '%$address%' 

but when the end use types in 

    "2343 S Cherry" 

It returns no results.  When the user type in only one word it works:

    "2343" 

it returns the correct record.  So this makes me think it is something about the spaces that are not allowing it to search the entire term. 

Can someone tell me how to build this so that the end user can search the address field with more than one word.  I know it has something to do with using LIKE, %% but I need it to allow spaces.  Thanks.

  