Where (SQLBuilder 1.2 API)

java.lang.Object
- com.github.eikecochu.sqlbuilder.QueryPartImpl<T>
- - com.github.eikecochu.sqlbuilder.Conditionable<Where>
  - - com.github.eikecochu.sqlbuilder.Where

All Implemented Interfaces:

BeforeGroupBy<Where>, BeforeOrderBy<Where>, BeforeUnion<Where>, QueryBuilder<Where>, QueryPart, QueryPartLinked<Where>, QueryPartSQL<Where>
```
public class Where
extends Conditionable<Where>
implements QueryBuilder<Where>, BeforeGroupBy<Where>, BeforeOrderBy<Where>, BeforeUnion<Where>
```
The WHERE expression. Allows constraining a SELECT statement by multiple columns or subqueries.

Constructor Summary

Constructors
Modifier Constructor Description

protected Where(BeforeWhere<?> parent)

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method	Description
`Where`	`exists(QueryBuilder<?> query)`	Continues the condition with an EXISTS expression
`Where`	`exists(java.lang.String sql)`	Continues the condition with an EXISTS expression
`java.lang.String`	`string(QueryOptions options)`	Transforms this statement into an SQL string

Methods inherited from class com.github.eikecochu.sqlbuilder.Conditionable
and, col, col, col, col, col, colsEq, group, groupStart, or, values, values

Methods inherited from class com.github.eikecochu.sqlbuilder.QueryPartImpl
parent, sql

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeGroupBy
groupBy, groupBy, groupBy, groupBySQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeOrderBy
orderBy, orderBy, orderBy, orderBySQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.BeforeUnion
union, union, unionAll, unionSQL

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryBuilder
query, query

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPart
string

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartLinked
ext, parent, parent

Methods inherited from interface com.github.eikecochu.sqlbuilder.QueryPartSQL
sql

- Constructor Detail
  - Where
```
protected Where(BeforeWhere<?> parent)
```
- Method Detail
  - exists
```
public Where exists(QueryBuilder<?> query)
```
    Continues the condition with an EXISTS expression
    
    Parameters:
    
    query - The subquery to apply the EXISTS constraint on
    
    Returns:
    
    This instance
  - exists
```
public Where exists(java.lang.String sql)
```
    Continues the condition with an EXISTS expression
    
    Parameters:
    
    sql - The subquery to apply the EXISTS constraint on
    
    Returns:
    
    This instance
  - string
```
public java.lang.String string(QueryOptions options)
```
    Description copied from interface: QueryPart
    
    Transforms this statement into an SQL string
    
    Specified by:
    
    string in interface QueryPart
    
    Overrides:
    
    string in class Conditionable<Where>
    
    Parameters:
    
    options - The QueryOptions to apply for transformation
    
    Returns:
    
    The created SQL string