how using information_schema find same text from all columns ?
Have this :
SELECT *
FROM information_schema.columns
WHERE table_name like '%cb%';
Need to find all tables name start CB and some column contains the text "OutstandingAmount"