CREATE TABLE test.pass (
  column1 varchar(50) DEFAULT NULL,
  name varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  id int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (id),
  INDEX IDX_pass_name (name)
)
ENGINE = INNODB
AUTO_INCREMENT = 10000001
AVG_ROW_LENGTH = 46
CHARACTER SET latin1
COLLATE latin1_swedish_ci;

CREATE DEFINER = 'root'@'localhost'
PROCEDURE test.page1_xxx07(IN `name` varchar(255))
BEGIN
  SET @name = `name`;
  IF (LENGTH(`name`) > 0)
  THEN
    IF `name` = '±'
    THEN
      SELECT
        pass.id,
        pass.name
      FROM pass LIMIT 15;

    ELSE

      SET @sql = 'SELECT SQL_NO_CACHE SQL_SMALL_RESULT pass.id, pass.name FROM pass WHERE ';

      SET @sql = CONCAT(@sql, `name`, ' limit 5');      

      PREPARE SSql FROM @sql;
      EXECUTE SSql;
      DEALLOCATE PREPARE SSql;
    END IF;

  END IF;
END