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