Home > Software engineering >  How to use loop for like or ilike function?
How to use loop for like or ilike function?

Time:05-30

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 '           
  • Related