Mysql: Using Vi to Search and Replace

Case: Use vi in FreeBSD/ Linux server

# vi filename.sql

* Shift + :

: (use search command below)

Search (Wraped around at end of file):

 Search STRING forward :   / STRING.
 Search STRING backward:   ? STRING.

 Repeat search:   n
 Repeat search in opposite direction:  N  (SHIFT-n)

Replace: Same as with sed, Replace OLD with NEW:

First occurrence on current line:      :s/OLD/NEW

Globally (all) on current line:        :s/OLD/NEW/g

Between two lines #,#:                 :#,#s/OLD/NEW/g

Every occurrence in file:              :%s/OLD/NEW/g