CREATE PROCEDURE `sp_location_selectAllByTermAutoComplete`(
IN _term VARCHAR(99))
BEGIN

    SELECT
        `title` AS `value`,
        `keyword` AS `label`,
        `city_id`,
        `id` AS `locationtitle_id`
    FROM `locationtitle`
    WHERE
        MATCH(`keyword`) AGAINST(_term  IN BOOLEAN MODE)
    ORDER BY MATCH(`keyword`) AGAINST(_term  IN BOOLEAN MODE) DESC
    LIMIT 0, 10
;END//
	
SELECT
        `title` AS `value`,
        `keyword` AS `label`,
        `city_id`,
        `id` AS `locationtitle_id`
    FROM `locationtitle`
    WHERE
        MATCH(`keyword`) AGAINST('+NEW*'  IN BOOLEAN MODE)
    ORDER BY MATCH(`keyword`) AGAINST('+NEW*'  IN BOOLEAN MODE) DESC
    LIMIT 0, 10
	
CREATE PROCEDURE `sp_location_selectAllByTermAutoComplete`(
IN _term VARCHAR(99))
BEGIN

    SELECT
        _term as my_param,
        MATCH(`keyword`) AGAINST(_term  IN BOOLEAN MODE) as my_param_result,
        `title` AS `value`,
        `keyword` AS `label`,
        `city_id`,
        `id` AS `locationtitle_id`
    FROM `locationtitle`
    WHERE
        MATCH(`keyword`) AGAINST('+NEW*'  IN BOOLEAN MODE)
    ORDER BY MATCH(`keyword`) AGAINST('+NEW*'  IN BOOLEAN MODE) DESC
    LIMIT 0, 10
;END//