find_in_set($str,$field)
$str:需要查询字符串
$field:查询字段
某个字段包含某个值,若无结果则返回0
CREATE TABLE 'goods' (
'id' int(11) NOT NULL auto_increment,
'name' varchar(255) NOT NULL,
'type' varchar(255) NOT NULL,
PRIMARY KEY (`id`)
);
INSERT INTO 'goods'` VALUES (1, '张三', 'one,two');
INSERT INTO 'goods' VALUES (2, '李四', 'red,blue');
INSERT INTO 'goods' VALUES (3, '王五', 'one,blue');
查询goods表中,type字段存在‘one’的数据
$data = "select id from goods where find_in_set('one',type);
$data2 = "select id from goods where find_in_set('get',type); //返回值:0