Statement complesso PHP+MySQL

[optime]

UPDATE tableX SET columnA=columnB*10 WHERE ...search statement...