MySQL Error “Operand should contain 1 column”

2 This question already has answers here: Operand Should Contain 1 Column – MySQL NOT IN (3 answers) Closed 7 years ago.

I could find a lot of similar questions but no real solution for my problem.

My SQL query:

UPDATE ADRESSEN
SET EMAIL = 0
WHERE ID = (SELECT ID, COUNT(ID) AS COUNTER
FROM EIGENSCHAFTEN WHERE Kategorie = "BOUNCE" 
GROUP BY ID
HAVING COUNTER = 1)

The error code I receive is

#1241 - Operand should contain 1 column(s)

If I just use the query in the parentheses it works and the result is

ID | COUNTER
0002159 | 1

Where is my error? Thanks a lot for your help.

Related Posts:

  1. Cannot add or update a child row: a foreign key constraint fails
  2. How to make MySQL table primary key auto increment with some prefix
  3. MySQL error 2006: mysql server has gone away
  4. sql query with multiple where statements
  5. Cannot delete or update a parent row: a foreign key constraint fails
  6. Syntax error due to using a reserved word as a table or column name in MySQL
  7. MySQL root password change
  8. Installation of MySQL for Visual Studio 1.2.8 failed
  9. How do I import an SQL file using the command line in MySQL?
  10. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  11. Select from multiple tables without a join?
  12. SQL Query Where Field DOES NOT Contain $x
  13. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  14. Mysql command not found in OS X 10.7
  15. MySQL – UPDATE query based on SELECT Query
  16. grabbing first row in a mysql query only
  17. mysqld_safe Directory ‘/var/run/mysqld’ for UNIX socket file don’t exists
  18. Order a MySQL table by two columns
  19. MySQL AS keyword
  20. Should I use the datetime or timestamp data type in MySQL?
  21. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  22. How do I change the data type for a column in MySQL?
  23. Generating a random & unique 8 character string using MySQL
  24. MySQL > Table doesn’t exist. But it does (or it should)
  25. Unknown Column In Where Clause
  26. Cannot connect to Database server (mysql workbench)
  27. mysqld: Can’t change dir to data. Server doesn’t start
  28. How to solve “Error: MySQL shutdown unexpectedly”?
  29. Can you do a For Each Row loop using MySQL?
  30. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  31. Drop all databases in MySQL
  32. How to properly create composite primary keys – MYSQL
  33. Failed to Connect to MySQL at localhost:3306 with user root
  34. MySQL – count total number of rows in php
  35. How to get the count of each distinct value in a column?
  36. Data is not constantly loading from custom wordpress table
  37. How to run WordPress across 2 VMs for high availability
  38. Mysqldump add drop table?
  39. How to disable `SQL_CALC_FOUND_ROWS` [duplicate]
  40. “#1067 – Invalid default value for ‘post_date'” when trying to reset AI after backup
  41. SQL query to update post_date (one post = one single date & time)
  42. #1115 – Unknown character set: ‘utf8mb4’
  43. WordPress Deadlock Error
  44. How to do a MySQL dump from production site without using a search and replace script for local development?
  45. How to bulk edit canonical url’s in SQL?
  46. Concurrent / simultaneous MySQL connections
  47. How to check for empty and not a failure
  48. How many ‘wp_insert_post’ calls can be performed in one shot, in a very long ‘for’ loop?
  49. Keeping database within limits, please help!
  50. Best settings for MySQL to speed up site? [closed]
  51. HTML Entities in Post Title
  52. Distinction on meta value on pre_get_posts
  53. Can’t find my wordpress DB in phpmyadmin
  54. Deprecated: mysql_connect():
  55. $wpdb select all meta for each post
  56. Calculate average crossing post categories
  57. WordPress plugin overloading with tmp tables
  58. Replacing link URL ending strings via MySQL
  59. Many slow queries post_type = ‘attachment’;
  60. SQL command to convert all tags in lowercase?
  61. Problem with admin login after deployment
  62. Find out how many times the user has logged in
  63. Is it possible to create a WordPress table using array and loop?
  64. Can’t run database query
  65. How to stop $wpdb from prepending database name
  66. Match tag names with form titles
  67. Error missing MySQL extension
  68. Replace a character in all post titles and slugs
  69. Getting Error Trying to Create Table
  70. Best approach for a custom database filling in WP custom post types
  71. Understanding custom php that reads from WP MYSQL
  72. Why doesn’t custom mysql query return results? Is syntax correct?
  73. List users with the most posts in the last 30 days
  74. Insert two row in wordpress database
  75. Way to extract wordpress data from folder backup
  76. SQL statement using placeholder is not returning results
  77. How to Bulk find and replace MySQL for post image url
  78. Wpdb query with dynamic table name
  79. Regular XML-RPC timeouts
  80. update multiple rows in mysqli table base on two values
  81. WordPress asks to install, but is already installed?
  82. How can I verify WordPress nonce from the following code?
  83. How to write in MySQL more characters in user_nicename
  84. An SQL query to find orphaned image attachments and their meta
  85. $wpdb->get_var not returning count
  86. Custom user query – orderby meta_key (that may not exist)
  87. How to get Attachments(image) with specific width\height ratio
  88. What is the cron doing?
  89. Apache Redirect based on WordPress permissions
  90. SQL error on restoring database
  91. MySQL database gives blank page (white screen of death)
  92. Datatabase error: Commands out of sync
  93. why is $wpdb->update() causing a DB error from within wp_set_password()
  94. Global MySQL replacing of text patterns/matches
  95. WP_Query with LIKE returns strange query
  96. Initialization of table in database using ‘CREATE … IF NOT EXISTS’
  97. mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
  98. How do I load a sql.gz file to my database? (importing)
  99. How to find source of these strange SQL queries?
  100. Batch Replace URLs in WordPress Database

Leave a Comment

tech