replace stuff in database..

[Anon]

I have a row that has h.c.state

state = the actual state the person is in.

I need to change about 50,000 entries to be
high.cost.state

is there a simple way to do it?

Thanks

[[deleted]]

UPDATE table SET column = REPLACE(column, 'h.c.', 'high.cost.')

Matt Wade
http://codewalkers.com

[Anon]

thanks dude..that worked perfect.

I appreciate your help.