mysql查询字符串包含的个数_MySQL 查询某个字段包含一个字符串的SQL语句

MySQL 查询某个字段包含一个字符串的SQL语句

一、新建表test_user，执行下面的sql 语句

DROP TABLE IF EXISTS `test_user`;

CREATE TABLE `test_user`  (

`id` int(11) NOT NULL,

`name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

`hobby` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,

PRIMARY KEY (`id`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

INSERT INTO `test_user` VALUES (1, 'beibei', 'feifei,guanguan,xiangxiang');

INSERT INTO `test_user`(`id`, `name`, `hobby`) VALUES (2, 'feifei', 'call');

表结构如下:(注意两个字符串之间的分割是英文逗号)

二