Petit Swoole DB

$selector = (new TableSelector('user')) ->leftJoin('post', 'messageOwner', 'message') ; $selector->where() ->firstCondition(new Condition( new ConditionElement(ConditionElementType::var, 'name', 'user'), ConditionOperator::equal, new ConditionElement(ConditionElementType::const, 'john') ))->andCondition(new Condition( new ConditionElement(ConditionElementType::var, 'subject', 'message'), ConditionOperator::like, new ConditionElement(ConditionElementType::const, '%hiring%') )) ;