This SQL is helpful when searching for specific strings within SQL code. I have used this code to search in databases too many times to mention. It is especially helpful when looking at a legacy database that I have never looked at before when trying to find things.
WHERE id IN (
WHERE TEXT LIKE '%Outstanding orders confirmed %'
ORDER BY NAME