rtop partial match should work better

[videoP]

if coursename is a "full" match to something it shouldn't return a partial match

instead of sorting by entries, sort by coursename length then entries?
maybe ignore length of the mapname ?

sort by length of mapname excluding anything before '(', and '(' and ')' themselves

would this require coursenames to be unique?

[videoP]

maybe something like
SELECT DISTINCT replace(coursename, "%(", "")

but replace doesn't accept % as a wildcard so that wont work

[videoP]