string concat in mysql

Question

delimiter //
create procedure ProductViewAllByName(p_productName longtext)
begin
select  productId as 'Product Code',
        productName as 'Name',
        productGroupId as 'Group ID',
        manufactureId as 'Manufacture ID',
        stockMinimunLevel as 'Stock Minimum Level',
        stockMaximimLevel as 'Stock Maximum Level',
        description as 'Description',
        unitId as 'Unit ID'
        FROM tbl_Product
where productName like p_productName+'%' ;
end //
delimiter ;

error

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+ '%' ; end' at line 12

Use CONCAT() for that

Alma Do
– Alma Do

2013-12-11 08:16:44 +00:00
Commented Dec 11, 2013 at 8:16 — Alma Do
– Alma Do, Commented Dec 11, 2013 at 8:16

gbejic · Accepted Answer · 2013-12-11 08:16:46Z

1

Maybe you can do it with CONCAT() function

where productName like CONCAT(p_productName , '%');

answered Dec 11, 2013 at 8:16

gbejic

3021 silver badge5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ravnur · Accepted Answer · 2013-12-11 08:17:21Z

1

replace where condition with:

where productName like CONCAT(p_productName, '%')

answered Dec 11, 2013 at 8:17

ravnur

2,85223 silver badges28 bronze badges

Collectives™ on Stack Overflow

string concat in mysql

error

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

error

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related