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.

  1. 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.

  2. 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

    Second time this question has come up today. Check what the manual says about RLIKE, and REGEX.

      Sorry man,

      Did not realize posting questions twice was that big of an issue

        Something you seem to see a lot of here is everyone saying "read the manual". For some folks the manuals are quite honestly not much help at all.

        Real life examples are the absolute way to learn....not to 'read the 'manual'...

          Thank you for the reply. I learn better hands on and from examples rather than reading. I will research and look up things but looking at code and examples are much better. I am a beginner at php and mySQL and I think I am catching on quite nicely.

            Write a Reply...