MySql 的一些特殊需求

需求：数据库info表中name字段，值为Beijingcar、Beijingpeople、Beijinghouse等；将该字段以Beijing开头更新成BJ开头。

解决：可以使用MySQL内置的REPLACE函数，具体用法如下：

UPDATE 表名 SET 字段名 = REPLACE(object, 'search', 'replace');
eg:
update info set name = REPLACE(name,'Beijing','BJ') where name like 'Beijing%';

update gw_20200713_02_acat_astrouw set ref_domain='acta.astrouw.edu.pl';
update gw_20200709_02_ethics set ref_domain='www.journals.uchicago.edu';
select series_id from journals_series_id where issn="1758-3756" or issn_rel="1758-3756";
select series_id from journals_series_id where issn in ("2327-5626","123");