mysql 不返回任何行，但所有关闭的单词在 sql 和 DB 上可用

Question

我的数据库是:

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

CREATE TABLE IF NOT EXISTS `oc_artists_tags` (
  `artists_tag_id` int(11) NOT NULL AUTO_INCREMENT,
  `artist_id` int(11) NOT NULL,
  `artist_tag` varchar(50) NOT NULL,
  PRIMARY KEY (`artists_tag_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=203 ;

INSERT INTO `oc_artists_tags` (`artists_tag_id`, `artist_id`, `artist_tag`) VALUES
(1, 113, 'ke$ha'),
(2, 113, 'kesha'),
(3, 113, 'keshha'),
(4, 113, 'ke'),
(5, 113, 'ha');

我的 sql 是:

SELECT * FROM `oc_artists_tags` 
WHERE `artist_tag` LIKE '%ke$ha%' 
  AND `artist_tag` LIKE '%kesha%' 
  AND `artist_tag` LIKE '%keshha%' 
  AND `artist_tag` LIKE '%ke%' 
  AND `artist_tag` LIKE '%ha%'

当我运行这段代码时，我得到了这个:

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0005 sec)**

为什么？问题出在哪里？

Answer 1

您需要OR谓词:

SELECT * 
FROM `oc_artists_tags` 
WHERE `artist_tag` LIKE '%ke$ha%' OR 
      `artist_tag` LIKE '%kesha%' OR
      `artist_tag` LIKE '%keshha%' OR 
      `artist_tag` LIKE '%ke%' OR 
      `artist_tag` LIKE '%ha%'

通过使用 AND 就像在说:给我获取带有 ke$ha and 标签的记录，比如 kesha等

Demo here