根据表搜索结果 [英] Searching the result as per the table

问题描述

我想知道一个搜索SQL查询

我有一个表，并且该表有一些字段.

表1
名称，年龄，地址1，地址2，价格，
还有一个列名Keys是一个字符串
字段是age，name，delhi.computer…ect

如果用户想要在同一张桌子上搜索某些东西，那么他将输入一个键.每次都可能不同.用户可以搜索结果.

I want to know a a search sql query

i have a table and there are some fields of that table.

Table1
name, age ,address1,address2,price ,
and there is also a column name Keys which is a string
and fields are age,name,delhi.computer …ect

if the user want so search something on the same table1 so he will enter a key . and it can be different in every time . and user can search the result .

推荐答案

尝试:

SELECT * FROM Table1 WHERE Keys LIKE '%user input%'

这篇关于根据表搜索结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！