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.

May 5 '12 #1

johny10151981

try this query

for explanation please read pattern matching

May 7 '12 #2