delimiter //
CREATE PROCEDURE ShowCorrelation()
begin
declare ProductID int;
declare YX_KeysWord varchar(50);
declare YX_ProductName varchar(50);
select YX_KeysWord=YX_KeysWord,YX_ProductName=YX_ProductName from YX_Product where YX_ID = ProductID;
select YX_ID,YX_ProductName,YX_Spic from YX_Product where (YX_ProductName like '%'+YX_ProductName+'%' or YX_KeysWord like '%'+YX_KeysWord+'%') and yx_id<>ProductID order by YX_AddTime desc limit 8;
end;//
在 select YX_ID,YX_ProductName,YX_Spic from YX_Product where (YX_ProductName like '%'+YX_ProductName+'%' or YX_KeysWord like '%'+YX_KeysWord+'%') and yx_id<>ProductID order by YX_AddTime desc limit 8;报错了,请问是模糊查询的错误码?
CREATE PROCEDURE ShowCorrelation()
begin
declare ProductID int;
declare YX_KeysWord varchar(50);
declare YX_ProductName varchar(50);
select YX_KeysWord=YX_KeysWord,YX_ProductName=YX_ProductName from YX_Product where YX_ID = ProductID;
select YX_ID,YX_ProductName,YX_Spic from YX_Product where (YX_ProductName like '%'+YX_ProductName+'%' or YX_KeysWord like '%'+YX_KeysWord+'%') and yx_id<>ProductID order by YX_AddTime desc limit 8;
end;//
在 select YX_ID,YX_ProductName,YX_Spic from YX_Product where (YX_ProductName like '%'+YX_ProductName+'%' or YX_KeysWord like '%'+YX_KeysWord+'%') and yx_id<>ProductID order by YX_AddTime desc limit 8;报错了,请问是模糊查询的错误码?
用预处理语句来做吧。
YX_KeysWord like concat('%',YX_KeysWord,'%')