471,062 Members | 1,898 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,062 software developers and data experts.

Pattern Matching


i am pretty new to mysql, sorry if the question is to dum.

how can i search " <a href="http://depositfiles.com/files/*********"> " and delete it?
every * is a number or a character.

i found this on the internet:
UPDATE wp_posts SET `post_content`
= REPLACE (`post_content`,
' ');

but it can be used only for exactly matches.
May 5 '12 #1
1 1781
1,059 1GB
try this query

Expand|Select|Wrap|Line Numbers
  1. SELECT wp_posts WHERE post_content REGEXP '<a href="http://depositfiles.com/files/\.{9}">'
for explanation please read pattern matching
May 7 '12 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

8 posts views Thread by gsv2com | last post: by
176 posts views Thread by Thomas Reichelt | last post: by
9 posts views Thread by Xah Lee | last post: by
5 posts views Thread by olaufr | last post: by
9 posts views Thread by Jim Lewis | last post: by
2 posts views Thread by Ole Nielsby | last post: by
1 post views Thread by VanKha | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.