[SOLVED] Newbie Question

[zontrakulla]

Hello, i'm still a newbie on mysql, i have a phpbb running and i want to move all banned users to a group by sql query.. The logic is:

 

getting ban_userid values which is bigger than 0 from phpbb_banlist table and update their group_id value to 10 in phpbb_users table. phpbb support guys seems not willing to help in mysql questions 

[Maq]

You need to use a LEFT JOIN and an UPDATE.

[zontrakulla]

wow complicated 

[zontrakulla]

Sorry couldn't find the edit button, i'm completely lost about using LEFT JOIN  :-\

[corbin]

What exactly do you not get about it?

[zontrakulla]

Using it, never seen "left join" before 

[corbin]

http://www.phpfreaks.com/tutorial/data-joins-unions

http://www.w3schools.com/Sql/sql_join.asp

http://www.sql-tutorial.net/SQL-JOIN.asp

http://www.tizag.com/sqlTutorial/sqljoin.php

[zontrakulla]

I guess i did it.

UPDATE phpbb_users
INNER JOIN phpbb_banlist
ON user_id = ban_userid
SET group_id = 10

 

Thanks.

[Maq]

Yeah that looks about right.  Although, you may need a left join rather than inner, but if it works I guess I'm wrong.