[Solved] Mysql help

[Jeet Kune Do]

Hello everyone.

I want to add “delivery 1-2 days” when the items are on stock on every products that I have in my store and when they are not to “delivery 5-10 days”.

I know that could be done in BO but I have over 1000 products.
I woul like to add this text true mysql so it will update all my products at once so I don’t have to type the same phrase for each products.

I know wich field I should modify but I dont now the code.

In:
ps_product_lang

the fields:

available now
available_later

INSERT, UDATE etc..
Some products has allready the text “delivery 1-2 days” I hope it won’t be a problem.

Could you be so nice to help me with the code?
Please it’s urgent!

I will really appreciate that!

Best regards!

[xbfish]

the text "delivery 5-10 days" is in which fields?

[xbfish]

Assuming you want to have both fields "available_now" and "available_later fields filled with “delivery 1-2 days”, the SQL statement is:

UPDATE ps_product_lang SET available_now = "delivery 1-2 days", available_later = "delivery 1-2 days";

The above will make ALL your products with the delivery text.

[Jeet Kune Do]

The delivery field 5-10 days should be into the field available_later.

UPDATE ps_product_lang SET available_now = "delivery 1-2 days", available_later = "delivery 5-10 days"; 

I don't have words to thank you!

You really save my day.

Wish you a great and succeseful week.

Thank you one more time.

Regards!

Jeet Kune Do

[xbfish]

No problem

THanks!

[Jeet Kune Do]

Hello to all,

I have changed some of the avaiable_later field in to "delivery 5-10 days", some into "delivery 10-15 days".

I will need the sql code to find and change only the "delivery 5-10 days" in to "delivery 4-8 days".

 

So the code should replace only the targeted phrase, not all the avaiable_later field.

 

Any help will be really appreciated!

 

Best regards!