Skip to content

Fix duplicating column to value #3

@Jarzon

Description

@Jarzon

$query = QB::delete($u)
->where($u->updated->dateAdd('30 DAY')->dateDiff($u->currentDate)->getOutput(), '<=', 0)
->whereRaw($u->status, '=', '-1');

SQL result : DELETE FROM users WHERE DATEDIFF(updated + INTERVAL 30 DAY, CURRENT_DATE) <= DATEDIFF(updated + INTERVAL 30 DAY, CURRENT_DATE) AND status = -1"

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions