SQL批量更改数据函数 replace


Warning: Undefined array key "HTTP_REFERER" in /www/wwwroot/prod/www.enjoyasp.net/wp-content/plugins/google-highlight/google-hilite.php on line 58

update consulting set answer = replace(answer,’400-678-2298′,’020-34273258′)

charindex 查找是否存在某个字符

SELECT *
FROM visitCustomer
WHERE (Adddate >= ‘2009-8-10 00:00:00’)
AND charindex(‘lvshou99.com‘, href) > 0
order by referrer desc