Select and Update in same time and gets displayed


I have this query:
SELECT MIN(id),CustomerName, Scenario,StepNo,InTransit,IsAlef,runNo,ResponseLength  
  FROM  `RequestInfo`
  WHERE  `CustomerName` =  'Hotstar'
    AND `ResponseContentType` like '%video/MP2T%'
    AND `RequestHttpRequest` like '%segment%' ;
which gives me output like this:-
+---------+--------------+----------+--------+-----------+--------+-------+----------------+----------+
| MIN(id) | CustomerName | Scenario | StepNo | InTransit | IsAlef | runNo | ResponseLength | IsActive |
+---------+--------------+----------+--------+-----------+--------+-------+----------------+----------+
|     139 | HotStar      | SearchTv | 1      | No        | No     | 1     | 410098         |     NULL |
+---------+--------------+----------+--------+-----------+--------+-------+----------------+----------+
I want to insert string "Yes" in the last column i.e "IsActive" when the above data is being displayed but only when the IsActive is set as NULL.


Best Answer :

Use This query
Update RequestInfo R inner join (SELECT MIN(id) as id,CustomerName, Scenario,StepNo,InTransit,IsAlef,runNo,ResponseLength  
  FROM  `RequestInfo`
  WHERE  `CustomerName` =  'Hotstar'
    AND `ResponseContentType` like '%video/MP2T%'
    AND `RequestHttpRequest` like '%segment%')as T on R.id = T.id set R.isAcitve ='Yes' Where  R.id = T.id;




TAGS : | | | | |