Allow payment by points with sql query?

[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