🚀 go-pugleaf

It looks like you want one text line to search all fields in multiple tables. Like we think, I do not beleive it possible in mySQL although posing it on their list might prove more worthy. It just seems to me that the way the fulltext index is setup it creates one file of the words and it can't deal with the file in the second table because it is a separate file. I think that's why all full-text indices must be made at the same time.

Since only prof names are in the one search I would have two areas, one for profs and one for course data. Perhaps a radio button to choose staff/courses near a single text area?

I might have just a list of profs. A click on one brings up the list of classes to make life even easier.