Help for this page

Select Code to Download


  1. or download this
    my $sql = <<ESQL;
    SELECT *,
           (name = 'Greg') + (age = 32) + (state = 'TX') AS score     
    ...
        WHERE score > 0
        ORDER BY score DESC
    ESQL
    
  2. or download this
    my $sql = <<ESQL;
    SELECT *
        FROM datable
        WHERE  ((name = ?) + (age = ?) + (state = ?)) > 0
    ESQL