mysql多个关键字的查询解决思路

mysql多个关键字的查询

PHP code

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->$list="";
    $car = array('name'=>array(0=>array('xm'=>'我是特别的'),1=>array('xm'=>'你好'), 2=>array('xm'=>'你好'), 3=>array('xm'=>'你好')));
    if(!$car['name']){
        $list='Nothing';
    }else{
        $i = 1;
        foreach($car['name'] as $nm)
        {
            if(strstr($list,$nm['xm']) && $i == 1)
            {
                $list = str_replace($nm['xm'],$nm['xm'].$i,$list);
                $list .= $nm['xm'].($i+1).',';
                $i++;
            }else{
                if(strstr($list,$nm['xm']))
                {
                    $list .= $nm['xm'].($i+1);
                    $i++;
                }else{
                    $list .= $nm['xm'].',';
                }
            }
        }
    }

登录后复制

SQL code

<!--

Code highlighting produced by Actipro CodeHighlighter (freeware)
http://www.CodeHighlighter.com/

-->$sql="SELECT * FROM table where table.title in ('$list') limit 0,10";

登录后复制