Home ›
Making Drupal nids into edit link from your command-line SQL Making Drupal nids into edit link from your command-line SQL
Submitted by Benjamin Melançon on April 11, 2009 - 1:12pm
I wanted to call this post "automating manual changes" but it's hard to get across the meaning of automating parts of the process that keep it manual.
Stolen directly from Growing Ventures Solutions post on migrating a messy Drupal 5 site to D6. (Primarily this post provides you with copyable text where there's had an image.)
SELECT CONCAT('http://example.com/node/', nid, '/edit') FROM node_revisions WHERE body LIKE '%problematicsomething%';
I just drag and drop links onto my browser to open them.
Resolution
Searched words:
mysql concatenation
concatenate text in MySQL
Comments
Post new comment