Query to execute if then in phpmyadmin

[ginjack]

Hello,

My phpmyadmin table is mismatched after i last edited it.
Is there a query i can use in this format =

IN table My_Products
If the "product ID"="300" then make the "product_Type"="Green" and "product_price"="4.00"
If the "STD Code"="5925" then make the "product_type"="Blue" and "product_price"="2.50"

Pls help. I have about 1000 list, and doing it manually is not going to help. I can create a bulk sql if you help me with just one as to how the code will be.

[DrByte]

You won't use an If/Then. Instead, you'll do mass-updates with a appropriate WHERE clauses. ie:

UPDATE My_Products set product_Type = 'Green', product_price=4.00 WHERE productID = 300;

UPDATE My_Products set product_type = 'Blue', product_price = 2.50 WHERE STDCode = 5925;

[ginjack]

You won't use an If/Then. Instead, you'll do mass-updates with a appropriate WHERE clauses. ie:

UPDATE My_Products set product_Type = 'Green', product_price=4.00 WHERE productID = 300;

UPDATE My_Products set product_type = 'Blue', product_price = 2.50 WHERE STDCode = 5925;

Thanks Drbyte. I had to make one change to it,

UPDATE My_Products set product_Type = 'Green', product_price=4.00 WHERE productID = '300';

The last one comes in quotation marks. thanks alot