sql frunction to convert degrees to N E S W compass points

deg_to_nesw.sql

DROP FUNCTION IF EXISTS deg_to_nesw;
DELIMITER //
CREATE FUNCTION deg_to_nesw(deg float) RETURNS char(3) DETERMINISTIC
-- based on: https://www.campbellsci.eu/blog/convert-wind-directions
BEGIN
    SET @directions = 'N,NNE,NE,ENE,E,ESE,SE,SSE,S,SSW,SW,WSW,W,WNW,NW,NNW,N';
	RETURN substring_index(substring_index(@directions,',',Round((deg MOD 360)/ 22.5,0)+1),',', -1);
END 

//

DELIMITER ;

select deg_to_nesw(72.8);

this is quite clever too.

SELECT deg_to_nesw(seq*22.5) FROM seq_0_to_15 ;