同一句sql在sqlserver里可以执行，在MySQL里报错？

Question

select a.* from stordoc as a,defultdata as b where a.orgname like '%'+ b.stockname+'%';

这句在mysql里写法不一样吗？报错如下：

Answer 1

select a.* from stordoc as a,defultdata as b where a.orgname like concat('%', b.stockname, '%');