syntax error in a mysql statement

Question

what is the error in the following mysql statement :

mysql> SELECT columnName  FROM tableName WHERE columnName LIKE  '%' + @variableName + '%';

ksogor · Accepted Answer · 2010-06-16 07:39:47Z

6

You can not concat strings using "+" symbol.

SELECT columnName 
FROM tableName 
WHERE columnName LIKE CONCAT('%',@variableName,'%');

answered Jun 16, 2010 at 7:39

ksogor

8732 gold badges7 silver badges15 bronze badges

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

Comments

CMartins · Accepted Answer · 2010-06-16 10:28:48Z

0

or

SELECT columnName FROM tableName WHERE columnName LIKE '%@variableName%';

answered Jun 16, 2010 at 10:28

CMartins

3,3235 gold badges41 silver badges61 bronze badges