Adding text to all posts of certain category in wordpress using MySQL

Hey to all!

I have some blog. In one of my category i have 500 posts. I need to insert one simply link on the top of all of this posts which are for example cat=5.

How can i do it using mysql?

Thanks in advance!

 

Why in the world would you do this using mysql? Do it using PHP. Simply check for post-category, and if the posts match the criteria, insert a link before the post (or after, or in, or or or)

 

I was thinking that its much easier to do with mysql, and i am not that good with PHP.

If you have some idea how to do this pls post code.

Thanks man.

 

Uhm. This is not mysql's job. What you'd have to do is something like this:

if (in_category($category_name, $post_name)) {
//insert the link here
}

Code (markup):