[color=#282828][font=arial, verdana, tahoma, sans-serif]is it possible to set all current products to “[/font][/color][color=#000000][font=Tahoma, Arial, Verdana,]Allow payment by points[/font][/color][color=#282828][font=arial, verdana, tahoma, sans-serif]” with a sql query? [/font][/color]
Hello, circlecity!
Please, try the following query
[color=#990099][font=monospace][size=1]UPDATE[/size][/font][/color][color=#000000][font=monospace][size=1] [/size][/font][/color][color=#008000][font=monospace][size=1]cscart_products
[/size][/font][/color][color=#000000][font=monospace][size=1] [/size][/font][/color][color=#990099][font=monospace][size=1]SET[/size][/font][/color][color=#000000][font=monospace][size=1] [/size][/font][/color][color=#008000][font=monospace][size=1]is_pbp
[/size][/font][/color][color=#000000][font=monospace][size=1] [/size][/font][/color][color=fuchsia][font=monospace][size=1]=[/size][/font][/color][color=#000000][font=monospace][size=1] [/size][/font][/color][color=#008000][font=monospace][size=1]'Y'[/size][/font][/color][color=fuchsia][font=monospace][size=1];[/size][/font][/color]
Best regards, Alt-team
Sorry, font is too small. The query is
[size=4][color=#990099][font=monospace]UPDATE[/font][/color][color=#000000][font=monospace] [/font][/color][color=#008000][font=monospace]cscart_products
[/font][/color][color=#000000][font=monospace] [/font][/color][color=#990099][font=monospace]SET[/font][/color][color=#000000][font=monospace] [/font][/color][color=#008000][font=monospace]is_pbp
[/font][/color][color=#000000][font=monospace] [/font][/color][color=fuchsia][font=monospace]=[/font][/color][color=#000000][font=monospace] [/font][/color][color=#008000][font=monospace]'Y'[/font][/color][color=fuchsia][font=monospace];[/font][/color][/size]
Worked like a charm!
Thank you