-
MySQL search using two keywords
Hi
I want to search a MySQL database using two keyword fields.
I want it to work this way - If both keyword fields have been selected then the results returned have matched both keywords. If only one keyword has been selected then the results returned have matched this keyword. If neither keyword field is selected then no results are returned.
Would anyone have a suggestion what kind of sql statement would perform this operation.
Thanks.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|