复杂搜索描述中的单词 [英] Complex Search for words in descriptions
问题描述
我属于一个音乐俱乐部，我们有一个所有音乐的数据库。
相关的表格是音乐，MusicID作为主键和标题（其他字段无关紧要）。 />
我们必须组建一个主题音乐节目，接下来的几个月主题是版税。因此，我想搜索诸如Emperor，Royal，King，Elizabethan，Tsar之类的单词。标题中的任何地方。这需要在一次通过而不是搜索每个单词分开
我的想法是从哪里开始的比较空白。我的想法是使用所有标题中的所有单词（没有重复项）创建一个临时表，并将其用作非常长的多选列表框的源。
然后在哪里？
感激不尽的任何想法。
菲尔
I belong to a music club and we have a database of all the music.
The relevant table is Music, with MusicID as the primary key and Title (other fields are irrelevant).
We have to put together a themed music program, and next months theme is royalty. So I want to search for words like "Emperor", "Royal", "King", "Elizabethan", "Tsar". anywhere in the title. This needs to be done in one pass rather than searching for each word separat
My mind is a comparative blank on where to start. My thoughts are to create a temporary table using all the words in all the titles (no duplicates) and use that a s source for a very very long multi-select list box.
Then where?
Any thoughts gratefully received.
Phil
推荐答案
从一个单词表开始你想找到 - [tblWord]。[Word]。
Start with a table of words you want found - [tblWord].[Word].
在另一个点上，请检查 PMs 并让我你可以回答菲尔。
On a separate point, please check your PMs and let me have a reply when you can Phil.
我很好奇为什么你认为你需要使用音乐表以外的桌子？
您可以根据音乐表创建连续表格。然后放在文本框中，用户在该文本框中键入以空格分隔的关键字列表。然后，无论是按下按钮还是失去对关键字文本框的关注，您都可以拆分关键字并构建Where子句并将其应用于表单过滤器。
基本上用户将输入：
I''m curious why you think you need to use a table other than the Music Table?
You could create a continuous Form based on the Music Table. Then drop on a textbox where the user types in a space separated list of keywords. Then either on a button press or losing focus on the Keyword textbox, you could split the keywords and build a Where Clause and apply it to the Forms Filter.
Basically the user would enter:
这篇关于复杂搜索描述中的单词的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
