I have a table that stores path of addresses / places each place has a code alias and it's path.
the question is how to translate the path of it's codes into a path of it's name in single query ?
the table looks like this
id | code | path | name 1 011 /100/20/011 Paula Street 34 100 /100 Rekwei 23 20 /100/20 Lengdi
the path from above is
100/20/011 and it's should be replaced by it's name
anyone can help ?