SQL query field add parentheses Error: Operand should contain 1 column (s)

SQL statement: Querying information for a single field

SELECT  from WHERE  like ('2_');

Then, since this is a statement in the stored procedure, the compilation does not report an error while executing the stored procedure, but the execution is reported incorrectly: Operand should contain 1 column (s); reason is not good explanation;

Here is the official explanation (MYSQL): https://dev.mysql.com/doc/refman/5.0/en/row-subqueries.html

Similar may be reported this error hint also: https://dev.mysql.com/doc/refman/5.0/en/subquery-errors.html

The solution to this problem is: normal drop write SQL can:

SELECT  from WHERE  like ('2_');

Remove the brackets!

SQL query field add parentheses Error: Operand should contain 1 column (s)