多關(guān)鍵模糊查詢,只需要改兩處:
$val='username like "%'.str_replace(' ','%" or username like "%',$keywords).'%"';
$sql="select * from fuzzyuser where {$val}";
高亮也不用重寫
$val='username like "%'.str_replace(' ','%" or username like "%',$keywords).'%"';
$sql="select * from fuzzyuser where {$val}";
高亮也不用重寫
2015-06-26
多關(guān)鍵字的模糊查詢:
$val='username like %'.str_replace(' ','%, or username like %',$val).'%';
select * from user where username like {$val}';
$val='username like %'.str_replace(' ','%, or username like %',$val).'%';
select * from user where username like {$val}';
2015-06-05