CODEWITHSUNDEEP
mysqlsql-updatewhere-clause
MOZ
MOZ

Reputation: 758

UPDATE STATEMENT with WHERE clause

I want to update table sheet and set column value of hproject to 'yes' where customer having hproject='yes'

UPDATE `sheet` SET `hproject` =  'yes' WHERE (
SELECT `customer`
FROM `sheet`
WHERE `hproject` =  'yes'
)

Above query is not working, i'll be grateful for any help or guidance.

Regards

Upvotes: 1

Views: 195

Answers (1)

echo_Me
echo_Me

Reputation: 37243

try that :

  UPDATE `sheet` SET `hproject` =  'yes' WHERE `customer` in (
  select * from(
  SELECT `customer`
  FROM `sheet`
  WHERE `hproject` =  'yes'
 )t
 )

Upvotes: 2

Related Questions