Mysql statement: a mysql deletion statement that deletes all URLs... for example, if an article contains a URL link, I want to delete all the URLs, www.baidu.com or www.baidu.com, and write the delete statement ------ solution ---------------- updatetables mysql statement
Could you tell me a mysql delete statement that deletes all URLs... for example, an article contains a URL link, I want to delete all the URLs, http://www.baidu.com or www.baidu.com to delete this delete statement in how to write
------ Solution --------------------
Update table set fieldName = fieldName. str_replace...
------ Solution --------------------
Delete records with URLs
Delete from table name where field name link '% www.baidu.com %'
Remove the URL from the content
Update table name set field name = field name. str_replace ('www .baidu.com ','')
------ Solution --------------------
It's okay to replace the http://www.baidu.com.
Attention sequence:
SQL code
Update table name set field name = field name. str_replace (http://www.baidu.com ', '') update table name set field name = field name. str_replace (www.baidu.com ','')
------ Solution --------------------
SQL code
Update table name set field name = field name. str_replace ('http: // www.baidu.com ', '') update table name set field name = field name. str_replace ('www .baidu.com ','')
------ Solution --------------------
I learned it. Thank you .......