32 'between' =>
'between',
43 public static function get()
45 return static::$operators;
48 public static function eq($columnSql, $valueSql)
52 return "{$columnSql} IS NULL";
54 return "{$columnSql} = {$valueSql}";
57 public static function neq($columnSql, $valueSql)
61 return "{$columnSql} IS NOT NULL";
63 return "{$columnSql} <> {$valueSql}";
66 public static function lt($columnSql, $valueSql)
68 return "{$columnSql} < {$valueSql}";
71 public static function lte($columnSql, $valueSql)
73 return "{$columnSql} <= {$valueSql}";
76 public static function gt($columnSql, $valueSql)
78 return "{$columnSql} > {$valueSql}";
81 public static function gte($columnSql, $valueSql)
83 return "{$columnSql} >= {$valueSql}";
86 public static function in($columnSql, $valueSql)
88 return "{$columnSql} IN (".join(
', ', (array) $valueSql).
")";
91 public static function between($columnSql, $valueSql)
93 return "{$columnSql} BETWEEN {$valueSql[0]} AND {$valueSql[1]}";
96 public static function like($columnSql, $valueSql)
98 return "{$columnSql} LIKE {$valueSql}";
101 public static function exists( $columnSql, $valueSql)
103 return "EXISTS ({$valueSql})";
106 public static function match($columnSql, $valueSql)
108 return "MATCH ({$columnSql}) AGAINST ({$valueSql} IN BOOLEAN MODE)";
static lt($columnSql, $valueSql)
static eq($columnSql, $valueSql)
static gte($columnSql, $valueSql)
static match($columnSql, $valueSql)
static between($columnSql, $valueSql)
static in($columnSql, $valueSql)
static lte($columnSql, $valueSql)
static gt($columnSql, $valueSql)
static neq($columnSql, $valueSql)
static exists( $columnSql, $valueSql)
static like($columnSql, $valueSql)