Re: update & select but return the results of the select

[Phillip Ward]

You can't invent syntax.
If you want to do an update and then select some data, then you need to use two statements to it.

update tableA 
set    varD = '1' 
where  varD = '0' ; 

select varA 
,      varB 
,      varC 
from   tableA 
where  varD = '0' ;

If you're really worried about the two being consistent, wrap them up in a Transaction (assuming you're using InnoDB).

Regards, Phill W.