Mysql查询可以'；t从查询中删除单词 - Mysql query can't remove word from query

Mysql query can't remove word from query

本文关键字：查询单词删除 Mysql | 更新日期: 2023-09-27

$terms = $db->GetAll("SELECT `TITLE`, `HITS` FROM `{$tables['category']['name']}` WHERE `STATUS` = '2' && `TITLE` NOT LIKE '%and%' ORDER BY `HITS` DESC LIMIT 0, $limit");

正在尝试从MYSQL查询中删除单词"and"。

在我的数据库中，我有：商业与经济体育和娱乐

我希望我的查询显示Business，Economy，Sports，Recreation，但不包含单词"and"。

这个查询并没有像我想象的那样工作，而是删除了其中包含单词"and"的任何TITLE。

$terms = $db->GetAll("SELECT REPLACE(`TITLE`, 'and', '') AS `TITLE`, `HITS` FROM `{$tables['category']['name']}` WHERE `STATUS` = '2' ORDER BY `HITS` DESC LIMIT 0, $limit");

$terms = $db->GetAll("SELECT replace(`TITLE`, 'and', ',') as title `HITS` FROM `{$tables['category']['name']}` WHERE `STATUS` = '2' ORDER BY `HITS` DESC LIMIT 0, $limit");

未经测试，但应该有效。此处记录了替换功能。

SELECT replace(title,'and',','), hits
FROM {$tables['category']['name']}` 
WHERE STATUS = '2'
ORDER BY hits DESC
LIMIT 0