CREATE TABLE OPTIONS (
  OPTION_KEY varchar(30) NOT NULL, 
  OPTION_VALUE varchar(100),
  DATE_CREATE timestamp NOT NULL,
  DATE_MOD timestamp NOT NULL,
  PRIMARY KEY (OPTION_KEY)
);

INSERT INTO OPTIONS (OPTION_KEY, OPTION_VALUE) VALUES ('BasePath', '/home/wladek/armoury');

DELIMITER //

CREATE FUNCTION FUNC_GET_OPTION (OPTION_KEY varchar(30)) RETURNS varchar(100)
BEGIN
	DECLARE OPTION_VALUE varchar(100);
	SELECT OPTION_VALUE INTO hi FROM OPTIONS WHERE OPTION_KEY = OPTION_KEY LIMIT 1;
	RETURN OPTION_VALUE;
END;//

SELECT OPTION_VALUE FROM OPTIONS WHERE OPTION_KEY = 'BasePath' LIMIT 1