CREATE TABLE `profiles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `reg_date` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `name` (`name`),
  KEY `surname` (`surname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

_____________________________________________
id   |    name    |  surname   |   regdate
_____________________________________________
1   |  Владимир   |   Иванов   |  01.01.2014

INSERT INTO `profiles`(`name`, `surname`) VALUES ('Владимир', 'Иванов');
INSERT INTO `profiles`(`name`, `surname`) VALUES ('Иван', 'Владимирович');

INSERT INTO `profiles`(`name`, `surname`) VALUES ('Владимир', 'Иванов') ON DUPLICATE KEY UPDATE `name`='Владимир', `surname`='Иванов';

CREATE TABLE `fixtures` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `ut` varchar(50) NOT NULL,
  `sport` varchar(50) NOT NULL,
  `country` varchar(25) DEFAULT NULL,
  `league` varchar(50) DEFAULT NULL,
  `template` varchar(255) DEFAULT NULL,
  `tournament` varchar(50) DEFAULT NULL,
  `status` varchar(25) NOT NULL DEFAULT 'Not started',
  PRIMARY KEY (`id`),
  UNIQUE KEY `sport_country_league` (`sport`,`country`,`league`),
  KEY `league` (`league`),
  KEY `country` (`country`),
  KEY `tournament` (`tournament`),
  KEY `sport` (`sport`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8

INSERT ignore INTO `fixtures` ( `ut`, `sport`, `country`, `template`, `tournament`, `league`, `status`) VALUES ('2014-09-19','Football2','International1','International Friendlies','2014','International Friendlies','Not started')

SELECT `id` FROM `fixtures` WHERE `sport` = 'Football' LIMIT 1

CREATE DEFINER = 'root'@'localhost' FUNCTION `getid`(
        sport_name CHAR
    )
    RETURNS bigint(20)
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
  /* пробую так */
  RETURN (select id from `fixtures` where `sport`=CONCAT("'",sport_name,"'"));

  /* или так */
 RETURN (select id from `fixtures` where `sport`=sport_name);
END;

SELECT getid('Football');

id        sport 
1	Football
20	Box

CREATE DEFINER = 'root'@'localhost' PROCEDURE `fixture_id`(
        IN id TINYINT(2)
    )
    NOT DETERMINISTIC
    CONTAINS SQL
    SQL SECURITY DEFINER
    COMMENT ''
BEGIN
	DECLARE sport_name  VARCHAR(20);

	SELECT sport INTO sport_name FROM `fixtures` WHERE `id`= id LIMIT 1; 
	SELECT sport_name;
END;

SELECT sport  FROM `fixtures` WHERE `id`= 1 LIMIT 1; /* ответ Football */
call fixture_id(1);  /* ответ Box  */

`id`= id