468,768 Members | 1,711 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,768 developers. It's quick & easy.

Pattern Matching

hi

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`,
'blabla',
' ');

but it can be used only for exactly matches.
May 5 '12 #1
1 1744
johny10151981
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}">'
  2.  
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
1 post views Thread by CARIGAR | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.