Loading

How to find a set of char from common char after 10 to 15 ch

siva nathan

6y718

Any one pls tell me the query for below I have a sentence following I need to remove particular char what I have mentioned below My self aaaa from xxxxxx am very much interested in cricket I love Sachin Here common word is cricket after that I need to search is there any Sachin key word finally I need to remove cricket I love Sachin

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Imran Shaikh6y ago
First add one Newcolumn in your table with name yourNewColumn for testing
then execute folowing query by updating respective database, table and column names
use yourdatabase
update yourtable set yourNewColumn=(select replace(yourColumn,'cricket i love sachin','') from [yourtable] where yourColumn like '%cricket%' and yourColumn like '%Sachin%' )
0