SELECT * FROM `shangpin` WHERE CONCAT(IFNULL(`title`,''),IFNULL(`dianhua`,''),IFNULL(`dizhi`,'')) LIKE ‘%关键字%’
表单保存前的检查
<script type="text/javascript">
/*
//点击下拉菜单后自动触发-----------------------
$(function(){
$("#dikou2").one("click",function(){
alert('选择抵扣时,请先通过上方输入框检测《账号余额》是否大于抵扣...