PHPMyAdmin question

[tres]

Dear all

Can someone give me the correct syntax to do this:

I have a big table

I want to change the value of a field in the column called "expires" to 123165147
if the value of a field in the column called "ID" is [email protected]
and for every row in the table

if that makes sense.

any ideas?

 

[MagicalTrevor]

IIRC doesn't PHPMyAdmin allow you to execute SQL... can't you just do...

update table
set expires = 123165147
where ID = '[email protected]'