[代码笔记]php+mysql实现模糊搜索关键词功能

SELECT * FROM test where tittle like '%1%'
//此段为sql语句，从test这个表中，查找出含有1的tittle字段

$sou = $_GET['sou'];
//此处省略conn连接mysql数据库步骤
$list = mysqli_query(conn,"SELECT * FROM test where tittle like '%1%' ");
while($myrow=mysqli_fetch_assoc($list)){
echo $myrow['title'].'--'.$myrow['key'];
echo '
';