mysql 匹配update

update 语句示例:
UPDATE `zjzc`.`QRTZ_SCHEDuler_state` SET `ip`='220.191.34.246' WHERE `sn`='3117764' and`startTime`='2016-07-20 00:02:40';


UPDATE QRTZ_SCHEDULER_STATE SET LAST_CHECKIN_TIME = 1472174086295 WHERE SCHED_NAME = 'ReportControlScheduler' AND INSTANCE_NAME = 'auto'

 if  (( $_ =~/$bs+$c/i ) or ($_ =~/$bs+`zjzc`.`$c`/i) )
 

 wjdb3:/root/sbin# cat a3.pl 
my $str="UPDATE QRTZ_SCHEDULER_STATE SET";
my $a="$ARGV[0]";
my $b="$ARGV[1]";
if ($str=~/$as+$b/i ){print "111111111
"};
if ($str=~/$as+`zjzc`.`$b`/i ){print "22222222
"};

wjdb3:/root/sbin# perl a3.pl UPDATE QRTZ_SCHEDULER_STATE
111111111

 
s       Match a whitespace character 匹配空白字符


wjdb3:/root/sbin# cat a3.pl 
my $str="UPDATE `zjzc`.`QRTZ_SCHEDuler_state`";
my $a="$ARGV[0]";
my $b="$ARGV[1]";
if ($str=~/$as+$b/i ){print "111111111
"};
if ($str=~/$as+`zjzc`.`$b`/i ){print "22222222
"};
wjdb3:/root/sbin# perl a3.pl UPDATE QRTZ_SCHEDULER_STATE
22222222