I have been searching the web for this but cant find it anywhere, i want to search my mysql database with php but i want it to find records if just one of the search term word are met.
eg.
Search term from form = "one two three"
My database has a record with a field that equals "one two" i want it to select this field by matching each word individually.
What would the query look like?
Hope i conveyed my message accross.
mcatominey
0
Newbie Poster
Recommended Answers
Jump to PostIs "one two three" one form field? If so, you will first need to check for more than one word and then form your query to search the record field for one OR two OR three.
I am sure this can be achieved in the SQL SELECT statement but …
All 2 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.