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

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

2025-02-27 20:30:58

推荐回答（3个）

回答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.

回答2：

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

回答3：

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

最新问答

申请关闭QQ空间后，里面的相册是不是都会消失，也就是所有数据

结婚证上身份证号码错误，需要改正.请问补办时要出实些啥证件