First search by current class (Select from spells where class==$class and name==$spell) then, if there aren't a top 5 do a raw search (select from spells where name == $spell). Display the "unsuggested" ones in grey and attach info display a warning to indicate they do not belong to that spell school for frontend use.
First search by current class (Select from spells where class==$class and name==$spell) then, if there aren't a top 5 do a raw search (select from spells where name == $spell). Display the "unsuggested" ones in grey and attach info display a warning to indicate they do not belong to that spell school for frontend use.