SQL Query To Search By Birthdate And Add To User Group

JBS

Active member
I need to be able to restrict under 18 members from being able to send or receive conversations. I have a user group that I can add them to with the permissions that I want. What SQL query would I use to find my under 18 members and add them to a specific user group?

At the same time... I need to run another SQL query to remove the members from that group once they have turned 18.

Is there anyone that could help me out with something like this? I would just run this manually on a monthly basis.
 

Similar threads

Top Bottom