MyBB Community Forums

Full Version: [SQL Query] To Change Dates in a Range
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Can someone give me the SQL Query to Change the Joined Year of all members from a range like 200x-201x and replace it with a single year like 2017? 
I am trying to learn Phpmyadmin and SQL queries on local server and can't find a solution to this particular case.

Any help is appreciated.
Should be as follows:

UPDATE mybb_users SET regdate = value WHERE regdate between value2 and value3;

Remember that the database stores timestamps in UNIX so the values will also have to be in UNIX. This site might help: https://www.unixtimestamp.com/