comenzi.sql

#XLS

update resource set format='xls' where format='XLS';
update resource set format='xls' where format='.xls';

#XML
update resource set format='xml' where format='.xml';
update resource set format='xml' where format='XML';
update resource set format='xml' where format='Xml';

update resource set format='csv' where format='CSV';
update resource set format='ods' where format='ODS';

update resource set format='xlsx' where format='XLSX';
update resource set format='pdf' where format='PDF';
update resource set format='html' where format='HTML';
update resource set format='kmz' where format='KMZ';

update resource set format='kml' where format='KML';
update resource set format='jpeg' where format='JPEG';
update resource set format='png' where format='PNG';

As a suggestion, to lowercase all strings you could use the SQL function LOWER() as in UPDATE RESOURCE SET format=LOWER(format)

Thanks a lot. 😄