Question

sql 查询多个数据字段，有多个关键字，而且个数不定。like的关键词在数组中，怎么在vb写。

有不确定个数的关键词在数组中，用like ‘%keyword1%’or like '%keyword1%'.......好像不行。
我的意思是like匹配多个关键词（keyword）中的一个或者几个，也就是实现多关键词模糊检索 。但是它的个数不确定，关键词我是用vb从外部文件读入的，放在一个数组里。能不能先用个循环判断关键词的个数？望哪位高手给出算法，具体代码也行！谢谢！

Answer 1

With the general improvement of the quality of life, the sea and land are not the only ways for people's travel, tourism , as the aviation industry has the advantage of time and gradually,it become the mainstream trend in transportation. In order to meet the needs of modern society the concept of a high time for a strong, ticket booking management system for the ticket booking office has brought great convenience. The purpose of this paper is to study the management of ticket booking system software development and application of ways, mainly because the management of today's cumbersome ticket reservations to the concept of time has a strong staff of the airline has brought a lot of inconvenience and the lack of a complete airline Booking of ticket management software, for Record of the booking, flight information, such as passenger information to facilitate the management, so the development of this software.
In this paper, VC programming language as a system to support the software to WIN9X/NT/XP operating system as a platform to support the VC to control the operating system software. Around the machine on database design and programming work in these two areas of practice, through some kind of database products and development tools (Access, SQL Server, Oracle, VFP, PB, VB, VC, Delphi, etc.) are familiar with and know, for a given of a specific problem, first of all, through its comprehensive analysis of the conceptual model for database design, relational database design logical structure to achieve 3NF or BCNF mode then RDBMS at the finish the design and specific features of the programming module require debugging, testing the success of the final submission of a small database applications.
In this paper, through computer networks to the client and the server connected to the database from the client to deal with information received, achieve flight information, ticket generation, sales statistics, etc. General information subsystem. Cost for the computer center, a computer sales business automation, as airlines reduce costs, improve sales, management decision-making based on timely and precise. Function of the software system at the completion of the internal source code directly. Through the operation manual, the user can know the basic working principle of the software. Operators only need to input some simple Chinese characters, numbers, can achieve their goal.

Keywords: VC, Access, Delphi, SQL Server.

Answer 2

只要like '%keyword1%'就可以了，后面不用or like '%keyword1%' 如果是实在要的话也 字段名 like ‘%keyword1%’or 字段名 like '%keyword1%'.

Answer 3

在前面加上 where 1 = 1
后面再加上其他的条件