Shell Programming and Scripting

I'm coding using BASH and have a requirement to replace apostrophes with backslash apostrophes. For example below:

Code:

I am here 'in my room' ok
Would be changed to:
I am here /'in my room/' ok

The original text is coming from a field in a MySql database and is being used by another process that REQUIRES a backslash in front of all apostrophes, thus I am unable to change that process at all.

in BASH I read the value from MySql and place it in a variable:
MyVAL="mysql command and query which only returns one value"
I have been successfully replaced double quotes with back slash double quotes but the apostrophe is a heck of a challenge.
How I do the double quotes is with this:

Code:

xMyVAL=`echo $MyVAL | sed -e 's/\"/\\\"/g'`

I hope this can be done easily with sed.

Try:

Code:

xMyVAL=`echo $MyVAL | sed "s/'/\\\'/g"`

Thank you for the quick reply. I just tried it and it did not work.
To ensure I did this correctly I even changed it to use this:

Code:

xMyVAL=`echo $MyVAL | sed "s/'/WW\'/g"`

So the original text is this:
Original text:
0904 MM - Int'l - Action required

With the code to ensure it would work (putting the WW in there) the new text looked like this:
0904 MM - IntWW'l - Action required

The WW's got in there but for some reason the back slash doesn't.

Any other suggestions?

Code:

MyVAL=`echo $MyVAL |sed "s/'/\\\\\'/g"`

That is the winnner! Thank you so much bartus11.
I just don't understand why there has to be some many backslash.

I think shell needs its backslashes because of the use of double quotes for sed code.