MySQL string replace

UPDATE your_table SET your_field = REPLACE(your_field, 'data/', 'catalog/') WHERE your_field LIKE 'data/%'

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.