I have a database with a field that can contain multiple keywords, separated with commas (e.g. "run, swim, bike, drive". Some records have one entry, some have multiples per the example. I would like to be able to search on 2 or more keywords at once. For example, return all the records that contain "run" or "swim" and only those. I'm not sure how to do it. The way I have it set up now, if I enter any two items in the search field, I get back all records, including those that don't have either term in the that field.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
tclemendor
I have a database with a field that can contain multiple keywords, separated with commas (e.g. "run, swim, bike, drive". Some records have one entry, some have multiples per the example. I would like to be able to search on 2 or more keywords at once. For example, return all the records that contain "run" or "swim" and only those. I'm not sure how to do it. The way I have it set up now, if I enter any two items in the search field, I get back all records, including those that don't have either term in the that field.
Any idea how to get this to work the way I want?
TC
Link to comment
Share on other sites
4 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.