php模糊查询技术「建议收藏」

<?php
$sql="select * from 表 where username like '%{$username}%'";
$result=mysql_query($sql);//提交
$users=array();
while($row=mysql_fetch_assoc($result)){//保持索引输出
	$row['username']=str_replace($huozhi, '<font color="red">'.$huozhi.'</font>',$row['username']);//高亮显示
	$users[]=$row; 
}
?>

<?php
if ($username) {
	echo '<h3>查询关键词<font color="red">.$username.</font>的结果</h3>';
	# code...
}
 if ($users) {
 	echo '<table width="500" border="1" cellpadding="5">';
 	echo '<tr bgcolor="orange"><th>用户名</th><th>邮箱</th><th>性别</th><th>爱好</th></tr>';
 	foreach ($users as $key => $value) {
 		echo '<tr>';
 		echo '<td>'.$value['username'].'</td>';
 		echo '<td>'.$value['email'].'</td>';
 		echo '<td>'.$value['sex'].'</td>';
 		echo '<td>'.$value['hobby'].'</td>'; 
 		echo '</tr>'; 
 	}

 	echo '</table>'; 
 }else{
 	echo "没有查询到相关用户";
 }
?>