如何用一条SQl语句把兴趣中提到嘉然的同学都搜索出来

Question

CREATE TABLE `student`  (
   `id` int NOT NULL AUTO_INCREMENT,
   `name` varchar(32) NOT NULL,
   `position` varchar(32) NOT NULL,
   `like` varchar(32) NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE = InnoDB CHARACTER SET = utf8;
 INSERT INTO `student` ( `id`, `name`, `position`, `like` ) VALUES
    ( 1, '金老板', 'A', '嘉然小姐的狗' ),
    ( 2, '栋栋子', 'A', '夸赞学弟好强啊' ),
    ( 3, '夏桑', 'B', '嘉然我真的好喜欢你' ),
    ( 4, '提莫', 'B', '种蘑菇' ),
    ( 5, '陈三金', 'B', '女装引流' ),
    ( 6, '金坷垃', 'B', '吸收氮磷钾' ),
    ( 7, '祖师爷', 'C', '南邮还是宁最卷' ),
    ( 8, '杂鱼', 'C', '欺负cxy' );

Answer 1

哈喽，模糊匹配like即可

select * FROM student WHERE student.like LIKE '%嘉然%'