addTable('users'); $sql->addWhere('users', 'username', 'john', SQLBUILDER_COMP_NOT_EQUAL, SQLBUILDER_LOGICAL_AND); $sql->addWhere('users', 'username', 'c', SQLBUILDER_COMP_STARTSWITH, SQLBUILDER_LOGICAL_OR); $sql->addRawWhere('GET_WAGE() > 2000'); $sql->addOrderBy('users', 'username', SQLBUILDER_ORDER_DESC); $sql->addOrderBy('users', 'userId', SQLBUILDER_ORDER_ASC); $sql->setLimit(3, 4); $sql->unsetLimit(); /* echo "
 
 where(b4 reset)";
print_r($sql->_where);
echo "
 
";
*/

//$sql->removeWhere('users', 'username');

/*
echo "
 
 where(after reset)";
print_r($sql->_where);
echo "
 
";
*/

echo $sql->generateQuery();
    
?>