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//