1 ALTER TABLE watch_profile
MODIFY field
enum('search_names', 'nom', 'freetext', 'mobile', 'nationalite',
2 'nationalite2', 'nationalite3', 'nick', 'web', 'networking',
3 'edus', 'addresses', 'section', 'binets', 'medals', 'cv',
4 'jobs', 'photo', 'corps');
6 UPDATE watch_profile
SET field
= 'search_names' WHERE field
= 'nom' OR field
= 'nick';
8 ALTER TABLE watch_profile
MODIFY field
enum('search_names', 'freetext', 'mobile', 'nationalite',
9 'nationalite2', 'nationalite3', 'web', 'networking','edus',
10 'addresses', 'section', 'binets', 'medals', 'cv', 'jobs',
13 # vim
:set syntax
=mysql
: