mysql - 带操作数的select语句中的count（*）应该包含1个列错误(count(*) in select statement with operand should contain 1 coloumn error)

Question

within a procedure statement, I could find this one select statement that currently has the "operand should contain 1 column" error.

(在过程语句中，我可以找到一条当前具有“操作数应包含1列”错误的选择语句。)

In the procedure statement, the first line also contains ("INTO Total Data").

(在过程语句中，第一行还包含（“ INTO总数据”）。)

I do not understand why this does not work.

(我不明白为什么这行不通。)

SELECT COUNT(*)
        FROM employees 
        WHERE firstname LIKE CONCAT('%', 'an', '%') 
        OR lastname LIKE ('%', 'an', '%');

  ask by Gusti Billi translate from so

Answer 1

等待大神答复