I have a table with more than 3000 records. I need to replace a particular string of all the rows wid some other string But when i am using replace function Its only replacing half of the rows of the table while the other half are not getting replaced.
I m using the following query:
UPDATE Table SET Source = REPLACE(Source, 'src="~/','src ="http://www.mywebsite.co.in/') WHERE (Source LIKE '%src="~/%')
Please let me know the solution to this!!
Thanks in advance!!