User login

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
in
Searched words: 
mysql concatenation concatenate text in MySQL

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

Comments

Post new comment

The content of this field is kept private and will not be shown publicly.
  • You may post code using <code>...</code> (generic) or <?php ... ?> (highlighted PHP) tags.
  • You can use Markdown syntax to format and style the text. Also see Markdown Extra for tables, footnotes, and more.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd> <img> <blockquote> <small> <h2> <h3> <h4> <h5> <h6> <sub> <sup> <p> <br> <strike> <table> <tr> <td> <thead> <th> <tbody> <tt> <output>
  • Syntax highlight code surrounded by the {syntaxhighlighter SPEC}...{/syntaxhighlighter} tags, where SPEC is a Syntaxhighlighter options string or "class="OPTIONS" title="the title".
  • Lines and paragraphs break automatically.

More information about formatting options

By submitting this form, you accept the Mollom privacy policy.