Just learning,,, know to query data is already in the database which table, but don't know which column, can use fuzzy or keywords to find ways to query out want to see the information? Press Ctrl + F in similar form input keywords can find that,

CodePudding user response:

No one answer???? Still no this style of query,,, told an

CodePudding user response:

Select * from table
Where field 1 like '% keywords %'
This is a fuzzy lookup fields

Select * from table
Where field 1 like '% keywords % 2 or field like' % keywords % '
This is two fields fuzzy search, and so on

CodePudding user response:

To know in which field, there is no good way