Top "Where" questions

What is the purpose of using WHERE 1=1 in SQL statements?

Possible Duplicates: Why would a sql query have “where 1 = 1” Why would someone use WHERE 1=1 AND <conditions> in a …

sql conditional-statements where

Can the "IN" operator use LIKE-wildcards (%) in Oracle?

I have searched this question, and found an answer in MySQL but this is one of those incidents where the …

sql oracle where wildcard

Rails: Using greater than/less than with a where statement

I'm trying to find all Users with an id greater than 200, but I'm having some trouble with the specific syntax. …

ruby-on-rails syntax where

CASE in WHERE, SQL Server

I'm doing some search, where users are choosing in dropdown some clauses. When they leave some box empty, I want …

sql sql-server case where

Can I do Model->where('id', ARRAY) multiple where conditions?

The title says it all. I get that I can do this : DB::table('items')->where('something', 'value')…

php laravel laravel-4 laravel-5 where

Get only records created today in laravel

How do I use the created_at field to get only the records that were created today and no other …

mysql date activerecord where laravel-5.1

If condition in LINQ Where clause

Can I use if clause with Linq where?

linq where

SQL JOIN where to place the WHERE condition?

I have two following examples. 1. Example (WHERE) SELECT 1 FROM table1 t1 JOIN table2 t2 ON t1.id = t2.id WHERE …

sql join where

How to use numpy.where with logical operators

I'm trying to find the indices of all elements in an array that are greater than a but less than …

python numpy where logical-operators

Linq: What is the difference between Select and Where

The Select and Where methods are available in Linq. What should every developer know about these two methods? For example: …

.net linq select where