This is a sample table:
name | cat ---------- hugo | sal bob | mgr mike | dev jeff | mgr john | dev
cat being Varchar.
cat reflects a category for these names, but I like to assign a priority to them, followed by a query to list them all, ordered by this priority.
What ways are possible? I could extract
cat into a second table, build a foreign key etc. But given my app is very simple and the structure might be non-changeable: What possibilities do I have to list the
mgr names first, followed by the
dev names, followed by the