Skip to content

Instantly share code, notes, and snippets.

@hans2103

hans2103/statements.sql

Created January 29, 2015 13:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hans2103/ca174fd9a287db5bb8f5 to your computer and use it in GitHub Desktop.
Save hans2103/ca174fd9a287db5bb8f5 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Tips & Tricks
Raw
statements.sql
SELECT *
FROM asdfg_posts
WHERE post_content LIKE '%href="wiki%';
SELECT *
FROM asdfg_posts
WHERE post_content LIKE '%href="/wiki%';
UPDATE asdfg_posts
SET post_content = replace(post_content, 'href="wiki', 'href="/wiki')
WHERE post_content LIKE '%href="wiki%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment