Help for this page

Select Code to Download


  1. or download this
    $row->{'inuse'} = $dbh->selectrow_array("SELECT COUNT(*) FROM Person W
+HERE Account_idAccount = ? AND JSON_EXISTS(custom, ?)", undef, $accou
+nt, "$." . $row->{'name'});
  2. or download this
    $row->{'inuse'} = $dbh->selectrow_array("SELECT COUNT(*) FROM Person W
+HERE Account_idAccount = 35 AND JSON_EXISTS(custom, '$.test3')");

die $dbh->errstr if $dbh->err;
die $row->{'inuse'} if $row->{'inuse'};
  3. or download this
    SELECT COUNT(*) FROM Person WHERE Account_idAccount = 35 AND JSON_EXIS
+TS(custom, '$.test3')