Replace Regular Expression in Sql

Question

I have a Table in Sql

Table 1:

========================================

ID     Text
1      i am a boy
2      boy!what are you doing?
3      that boy is nice
4      He is a Boy and go to school

========================================

i wants to Replace word boy(case insensitively ). like Replace boy to Man then output show be

Table 2:

========================================

ID     Text
1      i am a Man
2      Man!what are you doing?
3      that Man is nice
4      He is a Boy and go to school

========================================

what Query i need to write in Sql to do this

soulemane moumie · Accepted Answer · 2014-02-10 09:25:19Z

1

SELECT id, REPLACE( text, 'boy', 'man' )

FROM table1

answered Feb 10, 2014 at 9:25

soulemane moumie

1,1831 gold badge15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Nagaraj S · Accepted Answer · 2014-02-10 09:21:15Z

0

You can replace using Replace command something like this:

Update tablename Set Text = replace(Text, 'boy', 'Man');

Nagaraj S

13.5k6 gold badges35 silver badges53 bronze badges

answered Feb 10, 2014 at 9:19

vivekpansara

8971 gold badge6 silver badges14 bronze badges

If this answer helped you to solve your problem you should accept and upvote it.