Help for this page

Select Code to Download


  1. or download this
    package SQL::Builder::Select;
    use strict;
    ...
    
    
    1;
    
  2. or download this
    use SQL::Builder::Select;
    
    ...
    $select->limit_offset('10');
    
    print $select->return();
    
  3. or download this
    SELECT col1, col2 FROM table ORDER BY col1 LIMIT 10, 10
    
  4. or download this
    use SQL::Builder::Select;
    
    ...
    $select->where_and('col1 = 1', 'col2 = 1');
    
    print $select->return();
    
  5. or download this
    SELECT * FROM table WHERE (col1 = 1) AND (col2 = 1)
    
  6. or download this
    use SQL::Builder::Select;
    
    ...
    $select->where_logic('w AND o');
    
    print $select->return();
    
  7. or download this
    SELECT * FROM table WHERE ((col1 = ?) OR (col2 = ?)) AND ((col1 != ?) 
    +OR (col2 != ?))