Pattern Matching

[Mythnick]

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.

[johny10151981]

try this query

SELECT wp_posts WHERE post_content REGEXP '<a href="http://depositfiles.com/files/\.{9}">'
 

for explanation please read pattern matching