Not Solved [How To?] [SQL Query] To Change Dates in a Range
Not Solved
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.
Not Solved
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:
Plugin Count: I lost count.
Public Plugins are available here.
Official GitHub.
Please do not PM me for support unless asked to.

Forum Jump:

Users browsing this thread: 1 Guest(s)