Vb create connection to the database through ado reference object, then the problem is that I want to by a textbox enter a string, and then want through select queries related to the string field record connection and other records in the database table lookup the problems have been solved
In fact, the main problem is: similar to baidu search engine makes me input entry and then retrieved related fields
Example string: the language and find the fields related records such as language, Chinese, Chinese book, is to find contain language or culture or the language of all fields in short as long as have this string in a line, is to realize the matching level of tier 1 improvement of that kind of retrieval means that meaning, hope the great god play a little bit of the capability to help the younger brother, say thank you first! Ha ha

CodePudding user response:

In the textbox change event don't input the query is ok?

CodePudding user response:

The SELECT column_name (s)
The FROM table_name
WHERE column_name LIKE pattern
To use a wildcard

CodePudding user response:

2 floor because I'm a how do I enter a string wildcard is inserted into the string in the middle of the string position because I am in accordance with the textbox directly I think I should be combined with a comprehensive idea of try on the second floor,

CodePudding user response:

The SELECT column_name (s)
The FROM table_name
Language WHERE the field name 1 LIKE '% %' OR field name 2 LIKE '% % of Chinese' OR field name 3 LIKE '% % of Chinese...

The query function is no problem, but the speed will slow

CodePudding user response:

The content of the text in the text change events, and the like

CodePudding user response:

SELECT * FROM table_name WHERE (field name 1 & amp; The field name 2 & amp; The field name 3 LIKE '% %') OR (field name 1 & amp; The field name 2 & amp; The field name 3 LIKE '%, %)