PHPMYADMIN - change value.

[Artysta]

Hi guys,

I hope one of you will know the answer:

How do I get a value in town_id for all players to '2'

Currently there are maaany players with different town_id's. I want them to spawn in town_id:2.

How do I do that? I know there must be some SQL query, but don't know..

I found something like that:

update table_name set column_name='T' where column_name='';

anyone can help please?

 

[Ninja]

UPDATE `players` SET `town_id` = 2;