写法一、
select * from product where concat(id,name,title) LIKE '%关键字%';
写法二、
select * from product where concat(IFNULL(id,''),IFNULL(name,''),IFNULL(title,'')) LIKE '%关键字%';
写法一、
select * from product where concat(id,name,title) LIKE '%关键字%';
写法二、
select * from product where concat(IFNULL(id,''),IFNULL(name,''),IFNULL(title,'')) LIKE '%关键字%';