Mysql Tips

Find and Replace

update [table_name] set [field_name] = replace([field_name],'[string_to_find]','[string_to_replace]');

UPDATE set field = 'new_value' WHERE field = 'search_value'

eg.

update fe_users set usergroup = '' WHERE usergroup LIKE '0';
update fe_users set usergroup = '1000' WHERE usergroup LIKE '0,1000';