I need to update 1 field in every record of my database, how can i do this?
I have the following fields in my table:
I want to update the 'name' field in every record in the table (around 400) each with a different name.
Could i use something like this:
$query = "UPDATE table SET name = 'tom', name = 'bob', name = 'john', etc...";
Somehow i dont think the above query will work , lol. So how can i do this? thanks.