21,887
社区成员
发帖
与我相关
我的任务
分享
USE test;
DROP TABLE
IF EXISTS `member`;
create table `member`(
`id` smallint not null AUTO_INCREMENT,
`text` varchar(20) not null,
PRIMARY KEY (`id`)
) ENGINE = MyISAM DEFAULT CHARSET = utf8;
insert `member` values(79,'19,20'),(80,'182,82,18,2');
select * from `member` where find_in_set(19,`text`)>0;
select * from `member` where find_in_set(2,`text`)>0;
DROP TABLE `member`;
$Keywords="2";//关健词
$id="80";
$query="SELECT find_in_set($Keywords,`text`) from member where id='$id' and find_in_set($Keywords,`text`)";
$result=mysql_fetch_array(mysql_query($query));
if($result){
echo "".$result[0]."";
}else{
echo "不存在";
}