gistfile1.sql

SELECT
    q.question_id, q.text
FROM survey_question q
JOIN survey_question_folder f1 USING(question_folder_id)
JOIN survey_question_folder ancestors ON f1.path LIKE CONCAT(ancestors.path, '%') 
WHERE 
    q.text LIKE '%new%'
    OR f1.name LIKE '%new%' 
    OR ancestors.name LIKE '%new%' 
GROUP BY q.question_id ORDER BY NULL;