I basically need the data in the products description table but I want the corresponding category ID in this output also.
I am trying to use the product name, product description and product short description to pull the relevant keywords from so I can use it to populate meta_tags_categories_description.
I will then either insert the meta information through phpmyadmin, or insert it via an sql statement if anyone can tell me how I might be able to do that.
I tried learning sql today, but I think it would take days or weeks or? to fiqure out what should be a couple of simple statements.
If anyone could help that would really be great. I have a lot of linked products, if that makes a difference.
This is unrelated (but I will share) to find and replace things in phpmyadmin you can use the following statement and replace the relevant tables and fields.
Backup your database first!! I can see how powerful sql is from the hours this saves. That is why I am trying to figure out how to get what I need it the above question.
UPDATE tablename SET tablefield = replace(tablefield,"findstring","replacestring");
I would quote where I found this, but it might not be acceptable to do so in the forum??
Thanks for any help.