# Breadcrumbs Reihenfolge in MySQL

**URL:** <https://forum.shopware.com/t/breadcrumbs-reihenfolge-in-mysql/99750>\
**Category:** Shopware 6 (German)\
**Created:** [20. Mai 2023 um 06:50 UTC](https://forum.shopware.com/t/breadcrumbs-reihenfolge-in-mysql/99750 "2023-05-20T06:50:57Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![darkrain](https://avatars.discourse-cdn.com/v4/letter/d/b38774/32.png) [@darkrain](https://forum.shopware.com/u/darkrain)\
**Post date:** [20. Mai 2023 um 06:50 UTC](https://forum.shopware.com/t/breadcrumbs-reihenfolge-in-mysql/99750/1 "2023-05-20T06:50:58Z")

</div>

Hi Gemeinde,

habe versucht mir Redirects für den Umzug zu bauen. Beim Kategoriebaum / Breadcrumbs stimmt leider oft die Reihenfolge im Feld in der DB nicht ;-):

```auto
mysql> select breadcrumb from category_translation where name like "%Box%";
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| breadcrumb |
+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| {"018c1e2ff323487682a5c830da0cbf3e": "Mainsite", "5884418fe55f4c0ca4a458bec78528b9": "Ebene 2 Kategorie", "8165ece5f8b045d0ad0d8ff210d9587c": "Ebene 1 Kategorie"} |
| {"018c1e2ff323487682a5c830da0cbf3e": "Mainsite", "29fdee524c974d87aa00184c35b1f21e": "Ebene 1 Kategorie", "ccb4689615dc437ba317f3c9e6710da5": "Ebene 2 Katagorie"}

```

?  
Danke