Regular query strings that match the criteria

Because it is not familiar to the regular. It's annoying to have a problem.

For example, I would like to remove the following garbled parts, how to check out those garbled characters.

 ' serialno ' varchar NOT null COMMENT ' å?ˆå?œæµ?æ°´å? ', ' relativeserialno ' varchar DEFAULT NULL COMMENT ' Å ... ³è? " C "³è¯ æµ?æ°´å? ', ' artificialno ' varchar" DEFAULT NULL COMMENT ' äººå ¥å?ˆå?œç¼–å? ', ' CUSTOMERID ' varchar ($) Defau LT null COMMENT ' å®¢æˆ ç¼–å? ', ' CUSTOMERNAME ' varchar (+) DEFAULT NULL COMMENT ' å®¢æˆ å?? ǧ° ', ' businesstype ' varchar default null COMMENT ' ĸšåš¡å '? ç§ ', ' relativeaggreement ' varchar default NULL CO Mment ' Å ... ³è? " Çš "žªç?¯è´ 款å?? è®®å? ', ' CURRENCY ' varchar (5) DEFAULT NULL COMMENT ' å¸?ç§? (代ç ?:currency) ', ' Businesssum ' decimal (24,6) DEFAULT ' 0.000000 ' COMMENT ' é‡ ' é¢? ', ' Baserate ' decimal (10,6) DEFA ULT null COMMENT ' åÿºå‡†åˆ©ç?‡ ', ' ratefloattype ' varchar (+) DEFAULT NULL COMMENT ' 浮嚨类å?‹ (代ç ?:ratefloatty PE) ', ' Ratefloat ' decimal (10,6) default null COMMENT ' ň©ç?‡æµ®åš¨ ', ' businessrate ' decimal (10,6) default null COMMENT ' ň©ç?‡ ', ' returntype ' varchar () DEFAULT NULL COMMENT ' Å?还款方å¼? (代ç ?: Returnmethod) ', ' PURPOSE ' varchar (+) DEFAULT NULL COMMENT ' C "¨é€" (代ç ?:applypurpose) ', ' putoutdate ' varchar ( ) DEFAULT NULL COMMENT ' Å? ' Æ "¾æ-¥æœÿ", ' maturitydate ' varchar (all) default null COMMENT ' ň°æœÿæ-¥æœÿ ', ' vouchtype ' varchar (+) default NULL COMME NT ' ĸ»è¦?æ‹...ä¿?æ–¹å¼? (Ä»£ç ?:vouchtype) ', ' applytype ' varchar ($) DEFAULT NULL COMMENT ' C ' ³è¯ ç±»å?‹ (代ç ?:applytype) ', ' Extendtimes ' Decimal (24,0) default null COMMENT ' å± æœÿæ¬¡æ ° ', ' Lngotimes ' decimal (24,0) default null COMMENT ' Å€ÿ新还 Æ-§æ¬¡æ ° ', ' Golntimes ' decimal (24,0) default null COMMENT ' È¿˜æ-§å€ÿæ–°æ¬¡æ ° ', ' Drtimes ' decimal (24,0) default NULL CO Mment ' 债嚡é‡?ç» ' æ¬¡æ ° ', ' Putoutsum ' decimal (24,6) DEFAULT NULL COMMENT ' å ²å‡ºå¸?é‡ ' é¢? ', ' Actualputoutsum ' decimal (24,6) default null COMMENT ' Å ²å®?é™...出å¸?é‡ ' é¢? ', ' operateorgid ' varchar (+) default null COMMENT ' Å...¥è´¦æœºæ? ', ' O Perateuserid ' varchar (+) default null COMMENT ' ç»?åš?人 ', ' inputorgid ' varchar (+) default NULL COMment ' 登记机æ? ', ' inputuserid ' varchar (+) default null COMMENT ' 登记人 ', ' inputdate ' varchar (+) default null COMMENT ' 登记æ-¥æœÿ ', ' updatedate ' varchar (all) DEFAULT NULL COMMENT ' æ›´æ–°æ-¥æœÿ ', ' pigeonholedate ' varchar (all) DE FAULT NULL COMMENT ' Ž ' æ¡£æ-¥æœÿ ',

You can use the editor such as EditPlus ctrl+f to query and select the regular tick.

Then enter comment ' [\s\s]*?, you can query for eligible content. You can then directly replace ...

  ' Serialno ' varchar ' NOT null COMMENT ', ' relativeserialno ' varchar ' DEFAULT NULL COMMENT ' ', ' Artificialno ' V Archar default null COMMENT ", ' CUSTOMERID ' varchar" default null COMMENT ', ' CUSTOMERNAME ' varchar (+) DEF Ault null COMMENT ", ' businesstype ' varchar" default NULL COMMENT "', ' relativeaggreement ' varchar default NUL   L COMMENT ', ' CURRENCY ' varchar (5) Default NULL COMMENT ', ' Businesssum ' decimal (24,6) Default ' 0.000000 ' COMMENT ', ' Baserate ' decimal (10,6) default null COMMENT ', ' ratefloattype ' varchar (+) default null COMMENT ', ' ratefloat ' de Cimal (10,6) default null COMMENT ', ' businessrate ' decimal (10,6) default null COMMENT ' ', ' returntype ' varchar (+) DEF Ault null COMMENT ', ' PURPOSE ' varchar (+) default null COMMENT ' ', ' putoutdate ' varchar (all) default null COMMENT ' , ' maturitydate ' varchar (default null COMMENT ', ' vouchtype ' varchar ') default null COMMENT ' ', ' applytype ' VA Rchar () DEFAULT NULLCOMMENT ', ' Extendtimes ' decimal (24,0) default null COMMENT ' ', ' lngotimes ' decimal (24,0) default null COMMENT ', ' GO Lntimes ' Decimal (24,0) default null COMMENT ', ' Drtimes ' decimal (24,0) default null COMMENT ' ', ' putoutsum ' decimal (24,  6) Default null COMMENT ', ' Actualputoutsum ' decimal (24,6) default null COMMENT ' ', ' operateorgid ' varchar (in) default Null COMMENT ', ' operateuserid ' varchar (+) default null COMMENT ', ' inputorgid ' varchar (+) default null COMMENT ' ', ' inputuserid ' varchar (+) default null COMMENT ', ' inputdate ' varchar (all) default null COMMENT ', ' updatedate ' varchar (+) default null COMMENT ', ' pigeonholedate ' varchar (all) default null COMMENT ',

Regular query strings that match the criteria