mysql - 如何在字符串mysql之间插入单词

Question

我想插入字符串“Rs”。在字符串“pendrives above 2501”之间。因此输出将是“pendrives above Rs.2501”

现在 mysql 查询结果

    SELECT id,
    url,  replace(substring_index(replace(url, '-', ' '),
                '/pendrive/',
                - 1),
        'in india.php',
        '') as pagetitle
FROM
    sitemap
where
    category_id = 9 and (url like '%under%' or url like '%above%')

id            url                      pagetitle
1    pendrive-above-2501.php       pendrive above 2501
1    pendrive-below-500.php        pendrive below 500
1    pendrive-below-700.php        pendrive above 700

Answer 1

选择 REGEXP_REPLACE(PAGETITLE, '(上面的 pendrive)'，'RS 上面的 pendrive。')来自 Isitemap在哪里 Category_id = 9 and (url like '%under%' 或 url like '%above%');