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


Forum Jump:


Users browsing this thread: 1 Guest(s)