Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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//
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement