Hey everyone. Can someone please give me the SQL code to change the newsletter field in "customers" to "1" for every customer? I'd really appreciate it.
Latest News: (loading..)
0
1 reply to this topic
#2
-
- Community Sponsor
-
- 7,731 posts
- Real Name:Geoffrey Walton
- Gender:Male
- Location:Norfolk, UK (close to the centre of the universe)
Posted 03 November 2009, 20:11
Try the sql section of www.w3schools.com
It will be along the lines of
update customers set newsletter=1
It will be along the lines of
update customers set newsletter=1
Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile
Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.
For links mentioned in old answers that are no longer here follow this link Useful Threads.
If this post was useful, click the Like This button over there ======>>>>>.
Virus Threat Scanner
My Contributions
Basic install answers.
Click here for Contributions / Add Ons.
UK your site.
Site Move.
Basic design info.
For links mentioned in old answers that are no longer here follow this link Useful Threads.
If this post was useful, click the Like This button over there ======>>>>>.
