In need of a query

[WoodiE55]

I have a Wordpress blog running on a MySQL database and I'd like to add a custom field with a key name of "googlead" and a value of "1".

Can someone give me a hand on a query that will add this custom field to all 425 posts on my blog?

[guido2004]

To add a field to a table, read this: http://dev.mysql.com/doc/refman/5.1/en/alter-table.html

[WoodiE55]

guido,

Thanks for the link - any chance you have one that's in plain english? I don't know the first thing about MySQL or running queries. :\

[longneck]

do you have access to a GUI tool like phpmyadmin? it's pretty self-explanatory for simple operations like adding a column to a table.

[guido2004]

What table do you want to add the field to?
What do you need this field for? Do you have to change some Wordpress PHP script as well?

[WoodiE55]

do you have access to a GUI tool like phpmyadmin? it's pretty self-explanatory for simple operations like adding a column to a table.

Yes I do have phpmyadmin on my server.

What table do you want to add the field to?
What do you need this field for? Do you have to change some Wordpress PHP script as well?

Custom fields are stored in the postmeta table on wordpress installs. No changes in php files are needed.

[guido2004]

Yes I do have phpmyadmin on my server.

Start PHPMyAdmin, open the database, open the structure view of the postmeta table, and look for a button that says 'add field' or something like that.

[WoodiE55]

Start PHPMyAdmin, open the database, open the structure view of the postmeta table, and look for a button that says 'add field' or something like that.

It's not just adding a field to the one table. This needs to be added to each post entry. This doesn't work.

[guido2004]

well, it's a start
Once you have the new field, do you have to put the value '1' in all rows, or in specific rows?