MySQL how to reverse where?
You could use the instr
function
SELECT *
FROM mytable
WHERE INSTR('/a/b/c', path) = 1
I think you can use LIKE
for find child or parent in next way:
-- select childs of /a/b/
select *
from paths
where path like ('/a/b/%');
-- select parents of /a/b/
select *
from paths
where '/a/b/' like concat(path,'%');
Test SQL LIKE online