求教大神，MySql存储过程拼接语句时如何拼接两个字段的值

[aa232610]

存储过程如下：
DELIMITER $$

DROP PROCEDURE IF EXISTS `test`$$

CREATE PROCEDURE `test`()
BEGIN
DECLARE sqlQuery VARCHAR(11000);
SET sqlQuery='select ';
SET sqlQuery=CONCAT(sqlQuery,' FROM user',' where firstname','' '','lastname','='''test test'');
PREPARE s1 FROM @sql;
EXECUTE s1;
DEALLOCATE PREPARE s1;
END$$

DELIMITER ;

主要目的是将FirstName和LastName两个字段加在一起，然后与某字符串比较是否相等或模糊查询

[wwwwb]

SET sqlQuery=CONCAT(sqlQuery,' FROM user where concat(firstname,\' \',lastname)=\'test test\'');

[aa232610]

帅哥，这样查询报错了，提示错误如下： 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 'NULL' at line 1 能再帮忙看看吗

[wwwwb]

你的语句，字段中有NULL值？

[wwwwb]

DELIMITER $$ DROP PROCEDURE IF EXISTS `test`$$ CREATE PROCEDURE `test`() BEGIN DECLARE sqlQuery VARCHAR(11000); SET sqlQuery='select * '; SET sqlQuery=CONCAT(sqlQuery,' FROM user where concat(firstname,\' \',lastname)=\'test test\''); SELECT sqlQuery; SET @SQL= sqlQuery; PREPARE s1 FROM @SQL; EXECUTE s1; DEALLOCATE PREPARE s1; END$$ DELIMITER ;

[aa232610]

非常感谢版主，解决了，可以结贴了