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