php - 将 if 语句和多个 sql 查询合并为一个查询

Question

我有一个服务器，它限制了每小时可以进行的 sql 查询的数量，所以我试图找到一种方法将我的所有 3 个 if 语句和 sql 查询组合成一个 sql 查询，我想知道是否那可能吗？请看一下我的代码:

$text1 = "one";
$text2 = "two";
$text3 = "three";

$data = SELECT text FROM tableName WHERE 
text LIKE '%$text1%' AND
text LIKE '%$text2%' AND
text LIKE '%$text3%' order by rand() limit 1;

if ($data == null) {
$data = SELECT text FROM tableName WHERE 
text LIKE '%$text1%' AND
text LIKE '%$text2%' order by rand() limit 1;
}

if ($data == null) {
$data = SELECT text FROM tableName WHERE 
text LIKE '%$text1%' order by rand() limit 1;
}

Answer 1

SELECT text,
((text LIKE '%$text1%') + (text LIKE '%$text2%') + (text LIKE '%$text3%')) as `matches` 
FROM tableName 
HAVING `matches` > 0
ORDER BY `matches` DESC, rand() LIMIT 1

这应该按照匹配的数量对值进行排序，因为每个表达式在匹配时将被视为整数 1，否则将被视为 0。