php - 我的主题栏包含很多不同的关键字，我该如何编写 SQL 查询？

Question

我想根据主题和类检索数据。类的列名称是 (Class_I_V Class_VI_VIII Class_IX_X Class_XI_XII)。

我的查询是这样的:

subject LIKE '%$search%' or subject LIKE '%$search%'
or subject LIKE '%$search%' or subject LIKE '%$search%'
or subject LIKE '%$search%' or Class_I_V LIKE '%$search%' ".

我在主题栏中有很多值。我是否要像这样给出所有主题组合 (subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%')？

因为我的主题栏包含很多关键字。 kinldy 看到数据库我的表是导师，列是主题。可以给我一个完美的查询吗

我的网址:http://tutorquery.comuv.com/search.php给物理或java或I-V类

search.php
<?php
if(isset($_POST['submit']))
{
$search=$_POST['search'];
$sql=mysql_query("SELECT name,subject,place,expyrs,Class_I_V FROM tutor WHERE subject LIKE '%$search%' or  subject LIKE '%$search%'  or  subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%' or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%'or subject LIKE '%$search%' Or Class_I_V LIKE '%Class I -V%' ");
while($row=mysql_fetch_array($sql))
{
?>
<tr>
<td><?php echo ++$sno; ?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['subject'];?></td>
<td><?php echo $row['place'];?></td>
<td><?php echo $row['expyrs'];?></td>
<td><?php echo $row['Class_I_V'];?></td>
</tr>
<?php
}
}
?>

Answer 1

由于 $search 变量将始终是单个搜索字符串，因此每个 LIKE 语句将是相同的。您的查询可以缩短至...

SELECT 
name, subject, place, expyrs, Class_I_V
FROM
tutor
WHERE
subject LIKE '%$search%'
    Or Class_I_V LIKE '%Class I -V%';