Is SQL you can use a select statement to search for LIKE words. Does any one have any code in mqSQL that will bring back records if I search for two different things.
I am searcing for eagle nest golf course. I would like it to return anything that has the words eagle, nest, golf, or course. The LIKE statement in SQL does not do that.
I am also providing a Zip Code search. I want the search to bring back all records where the first 3 numbers of the zip code match.
Any takers on these woudl greatly be appreciated.
THanks