I am currently asked to validate the result of a global search which to find all records containing some keywords cross whole database. To do so, I need to check all the rows in each table that have keywords. The result for this global search is ready and partially of the result looks like the one below:
table_name | column_name | keyword | cnt |
---|---|---|---|
Wf_Process | Name_EN | FEC | 11 |
Wf_Process | FTABLENAME | GB | 14 |
ICCClass | Name_EN | GB | 4 |
What I am trying to do is using the 'like' operator to extract all the data in each table where columns containing keywords. That is, I will use query such as:
select distinct Name_EN, FTABLENAME from Wf_Process where Name_EN like '