Quote:
Originally Posted by LD
Yeah, Dragon is a real bitch doing chores like that. I did figure out how to do it in mysql, I think...don't know if I am brave enough though...
|
If you have phpmyadmin it is pretty easy to search for terms like girlfriend and move them. Something like this:
Code:
update dl_sites set category='22' where title LIKE '%keyword%' and category='74'
You don't have to have the second part and category='whatever' unless you are only going to check a specific category.
Code:
update dl_sites set category='73' where title LIKE '%keyword%'
The % are wildcards so the title can be Blah Blah Girlfriend Blah and still move it.
