MySql functions to convert geocaching codes to id and back (Remove the GC, PR, and other prefixes)

gc_code_to_id

CREATE FUNCTION GC_ID_TO_CODE(p_id INT)
  RETURNS TEXT
  DETERMINISTIC
  RETURN IF (
    p_id < 65536,
	CONV(p_id, 10, 16),
    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(CONV(p_id+411120, 10, 31),
    'U', 'Z'), 'T', 'Y'), 'S', 'X'), 'R', 'W'), 'Q', 'V'), 'P', 'T'), 'O', 'R'), 'N', 'Q'), 'M', 'P'), 'L', 'N'), 'K', 'M'), 'J', 'K'), 'I', 'J')
  )

gc_id_to_code

CREATE FUNCTION GC_ID_TO_CODE(p_id INT)
  RETURNS TEXT
  DETERMINISTIC
  RETURN IF (
    p_id < 65536,
	CONV(p_id, 10, 16),
    REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(
	CONV(p_id+411120, 10, 31),
    'J', 'I'), 'K', 'J'), 'M', 'K'), 'N', 'L'), 'P', 'M'), 'Q', 'N'), 'R', 'O'), 'T', 'P'), 'V', 'Q'), 'W', 'R'), 'X', 'S'), 'Y', 'T'), 'Z', 'U')
  )