Not sure if this is possible

[Shadowing]

is it possible to add a statement in this select.

I only want this update to this column to happen if the column planet_tax_id is not equal to the column id

 

cant use the WHERE clause cause i have another  column updating also that isnt included in the code below

 

so is it possible to add a switch and still use the column in the switch

 

a = b ? a : b <<<< this type of switch forgot what its called Tarrany or something

 

"UPDATE planets SET tax_technology = planet_tax_id <> id ? 

tax_technology + ceil(laboratories * $laboratories_technology * efficiency * .05) 

: tax_technology 

WHERE id <> ''";

[Barand]

"a = b ? a : b" is a ternary function.

 

The SQL equivalent is IF() or a CASE clause.

[phpassassin]

php code

$tax_technology = (planet_tax_id <> id) ? tax_technology + ceil(laboratories * $laboratories_technology * efficiency * .05)  : $tax_technology;

 

 

mysql code

"UPDATE planets SET tax_technology = $tax_techology WHERE id <>'' ";