SELECT hno, zip, city, REPLACE (address,\' t.\' ,\' treet\' )
address FROM hotel where address like \'%tr%\'
The above replaces all addresses that contain the text "st." to "street".
This example came from the docs for MaxDB, but I think will work in MySQL and most other SQL database servers as well. I\'ve recently tried it with Access on a linked MS SQL server.
Source:
http://www.mysql.com/documentation/maxdb/71/817392b9b311d2a97100a0c9449261/content.htm