9 {{ upvoteCount | shortNum }}
9 {{ upvoteCount | shortNum }}

phpMyAdmin - How Do I Search and Add Custom Field

by -Jericho-
7 replies
I'm not that familiar with phpmyadmin but what I wanted to do is find a link in all my posts and add it to a custom field. Each link points to the same external domain but to a different page.

Can anyone point me in the right direction?
#add #custom #field #phpmyadmin #search
  • Profile picture of the author Nathan Wong
    sorry ， i dont know ， but i think its not diffcult...... hope u meet someone can help u
    {{ DiscussionBoard.errors[2557417].message }}
  • Profile picture of the author zeeshi570
    Hi,
    If you know the links just search them in phpmyadmin. You have search option in top menu. Or click on posts table and then click search to search from posts table only.
    Once you got the links just copy/paste them in custom fields.
    {{ DiscussionBoard.errors[2558089].message }}
    • Profile picture of the author -Jericho-
      Originally Posted by zeeshi570 View Post

      Hi,
      If you know the links just search them in phpmyadmin. You have search option in top menu. Or click on posts table and then click search to search from posts table only.
      Once you got the links just copy/paste them in custom fields.
      I tried searching for a portion of the link since they're all different and it kept coming up with nothing.

      I have over 10K posts to do or I would just do it in wordpress.
      Signature

      {{ DiscussionBoard.errors[2558274].message }}
  • Profile picture of the author phpbbxpert
    You will need to write a script to handle that, search and replace.
    Unless you plan on changing 10,000 posts 1 at a time in phpMyAdmin
    {{ DiscussionBoard.errors[2558489].message }}
    • Profile picture of the author -Jericho-
      Originally Posted by phpbbxpert View Post

      You will need to write a script to handle that, search and replace.
      Unless you plan on changing 10,000 posts 1 at a time in phpMyAdmin
      What kind of script would I need? I'll probably hire someone if that's the case but any feedback would be great so I don't get ripped off.
      Signature

      {{ DiscussionBoard.errors[2558511].message }}
  • Profile picture of the author phpbbxpert
    Well, typically it wouldn't be that bad, probably an hour to write it and test it.
    But since you have that many posts it gets a little trickier, as you can not run 10,000 queries against a database all in one shot. It'll crash.

    You also don't do this on a live database. This is done locally.
    So they do not need access to your admin panel, server, or anything like that.
    All they would need is a copy of the table that needs changing.

    If you want PM me.
    I have done database conversions which are similar but much more complicated.

    Also, are these links that you want to change in the posts or in custom meta boxes?
    {{ DiscussionBoard.errors[2558544].message }}
  • Profile picture of the author dealbert.net
    Why can't you use WebYog? Web-based mySql tool just plain sucks.
    {{ DiscussionBoard.errors[2579472].message }}

Trending Topics