The where condition is equivalent to where in sql. You can add multiple conditions, which get connected with AND. If you want to use an or, you have to insert this into the condition.
The lenght of a condition is limit by the column lenght of 250 characters. (Table: wp_wr_query_where).
You can use value replacement in the where condition. See Replacing Value section.