我有一个SQL搜索语句的例子,我试图按顺序找到字符串的一部分,首先是相关的。所以它首先搜索"一二三"的整个字符串,然后移动到"一二",然后是"二三",最后一直到一个单词,但它从不向后搜索。只按顺序。因此,例如,它永远不会搜索"三二一",只有"一二三",我想知道是否有可能将所有这些单个查询语句合并到单个查询中?谢谢你。
$text1 = "one";
$text2 = "two";
$text3 = "three";
SELECT text FROM tableName WHERE text LIKE "$text1 $text2 $text3"
SELECT text FROM tableName WHERE text LIKE "$text1 $text2"
SELECT text FROM tableName WHERE text LIKE "$text2 $text3"
SELECT text FROM tableName WHERE text LIKE "$text1"
SELECT text FROM tableName WHERE text LIKE "$text2"
SELECT text FROM tableName WHERE text LIKE "$text3"
是。你可以搜索它们,然后按相关性排序。这里有一个方法:
SELECT text
FROM tableName
WHERE text LIKE "$text1" OR
text LIKE "$text2" OR
text LIKE "$text3"
ORDER BY (text LIKE "$text1 $text2 $text3") DESC,
(text LIKE "$text1 $text2") DESC,
(text LIKE "$text2 $text3") DESC,
(text LIKE "$text1" ) DESC,
(text LIKE "$text2" ) DESC,
(text LIKE "$text3" ) DESC