i want to update table multiple row using IN statement

by

Your WHERE condition can be simplified like

UPDATE domain_information
SET company_name="aaa"
WHERE company_name="bbb";

More Related Contents:

  1. query about check constraint [closed]
  2. What is wrong with this multi-criteria WHERE statement?
  3. Is the SQL WHERE clause short-circuit evaluated?
  4. Generate Dates between date ranges
  5. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  6. How to print VARCHAR(MAX) using Print Statement?
  7. SQLite – How do you join tables from different databases?
  8. SQL statement to select all rows from previous day
  9. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  10. What does =* mean?
  11. Does MS Access support “CASE WHEN” clause if connect with ODBC?
  12. In SQL / MySQL, what is the difference between “ON” and “WHERE” in a join statement?
  13. Does Mysql have an equivalent to @@ROWCOUNT like in mssql?
  14. SQL Select Upcoming Birthdays
  15. MySQL, Get users rank
  16. SQL error “ORA-01722: invalid number”
  17. Favourite performance tuning tricks [closed]
  18. Query a database based on result of query from another database
  19. SQL Error: ORA-00942 table or view does not exist
  20. CHECK CONSTRAINT on multiple columns
  21. How to use multiple CTEs in a single SQL query?
  22. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  23. How to extract week number in sql
  24. Why do multiple-table joins produce duplicate rows?
  25. SQL count consecutive days
  26. what is the difference between GROUP BY and ORDER BY in sql
  27. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  28. COALESCE Function in TSQL
  29. SQL Sort Order with Null values last
  30. SQLite query, ‘LIKE’

Leave a Comment