mysql - Why does ExtractValue() fail in an UPDATE and succeed in a SELECT? -


when execute query...

update tbl a, (select id, extractvalue(content, '//a[contains(text(), "view")]/@href') url tbl) b set tbl.`url` = b.`url` 

...i see error:

error code: 1525 incorrect xml value: 'parse error @ line 57 pos 195: '</div>' unexpected (end-of-input wanted)' 

but when execute query...

select id, extractvalue(content, '//a[contains(text(), "view")]/@href') url tbl 

...the query succeeds.

why update query fail standalone select query succeeds?


Comments

Popular posts from this blog

resizing Telegram inline keyboard -

command line - How can a Python program background itself? -

php - "cURL error 28: Resolving timed out" on Wordpress on Azure App Service on Linux -