SELECT
                        node_v_name,
                        '/edzesi-lehetosegek/gyerekcsoportok/gyomro/' AS url
                  FROM
                        nodes
                 GROUP BY node_v_name
                 HAVING url LIKE CONCAT(node_v_name,'/%')
              ORDER BY
                        LENGTH(node_v_name) DESC
                LIMIT   1
            <br>Got error 28 from storage engine<br>/edzesi-lehetosegek/gyerekcsoportok/gyomro