Question

我有这一座标:“Beautiful sedimentset” (notice the Doublespace)

当我查询数据库时:

www.un.org/spanish/sc/presidency.asp * 摘自WHERE 标题LKE % 显示%。

and I search for "Beautiful sunset" (notice the single space) it won t return any results.

我如何解决这一问题?

Answer 1

split the string by space. now you have two strings something like $str1, $str2 trim this two strings(i.e remove leading and trailing whitespaces) then rebuild string $string = $str1+ % +$str2

Answer 2

引言

SELECT * FROM images WHERE where MATCH(title) AGAINST ( $string  IN BOOLEAN MODE)

查询

rel=“nofollow”http://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html

Answer 3

You could split your search string into multiple parts using the space and then build a sql like this for every part you have splitted:

SELECT * FROM images WHERE title LIKE  %$part[0]%  
or title LIKE  %$part[1]% 
or title LIKE  %$part[2]% 
or title LIKE  %$part[3]% 
...

• 确保双轨空间/空位。

Answer 4

您可以采取的一种方式是用地体取代地块,代之以野心特性:

    $string = str_replace(" ", "%", $string);
    $Query  = "SELECT * FROM images WHERE title LIKE  %$string% ";

Answer 5

如果你不了解你会再次获得什么东西(如果是全时的“血清点”,那么你就可以探索这种扼杀,并在此基础上提出质询。和......

$c = false;
$stringtosearch = "Beautiful sunset";
$query = "SELECT * FROM images WHERE";
foreach(explode(" ", $stringtosearch) as $b)
{
   if ($c)
   {
     $query .= " or";
   }
   $query .= " title LIKE " . $b;
   $c = true;
}

之后,你会随你的询问而获得可变的定购单。

友情链接