Untitled

Match partial words using MySQL Fulltext search?
CREATE TABLE IF NOT EXISTS `items` (
  `id` int(11) unsigned NOT NULL,
  `irn` varchar(30) NOT NULL,
  `name` varchar(225) NOT NULL,
  `description` text,
  PRIMARY KEY (`id`),
  FULLTEXT KEY `name_desc_irn` (`name`,`description`,`irn`),
  FULLTEXT KEY `name` (`name`),
  FULLTEXT KEY `description` (`description`),
  FULLTEXT KEY `irn` (`irn`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

id    name        irn          description
1     Widget A    ABC12345     testing ABC12345
2     Widget B    ABC-12345    the ABC is great

SELECT
    items.id as id,
    items.irn as irn,
    items.name as name,
    (
        ((MATCH (irn) AGAINST ('12345')) * 5) +
        ((MATCH (name) AGAINST ('12345')) * 4) +
        ((MATCH (description) AGAINST ('12345')) * 3) +
        (MATCH(name, description, irn) AGAINST ('12345'))
    ) AS relevance
FROM
    items
WHERE
    MATCH(name, description, irn) AGAINST ('*12345' IN BOOLEAN MODE)
HAVING
    relevance > 0
ORDER BY
    relevance DESC

WHERE irn LIKE '%12345' OR name LIKE '%12345' OR description LIKE '%12345'