Help for this page

Select Code to Download


  1. or download this
    my $sql = "SELECT COUNT(*) FROM Person WHERE Account_idAccount = 35 AN
+D JSON_EXISTS(custom, '$.test3')");
say "Running <<$sql>>";
my $res = $dbh->selectrow_array($sql);
...
  2. or download this
    my $sql = <<'SQL';
    SELECT COUNT(*) FROM Person WHERE Account_idAccount = 35 AND JSON_
+EXISTS(custom, '$.test3')
SQL
...