Top "Where" questions

How to use NULL or empty string in SQL

I would like to know how to use NULL and an empty string at the same time in a WHERE …

sql sql-server null where

Oracle SQL : timestamps in where clause

I need to look up rows within a particular time frame. select * from TableA where startdate >= '12-01-2012 21:24:00…

sql oracle where sql-timestamp

MySQL select with CONCAT condition

I'm trying to compile this in my mind.. i have a table with firstname and lastname fields and i have …

mysql select conditional-statements where concat

querying WHERE condition to character length?

I have a database with a large number of words but i want to select only those records where the …

sql conditional-statements where

Select records from NOW() -1 Day

Is there a way in a MySQL statement to order records (through a date stamp) by >= NOW() -1 so …

mysql select where datestamp

SQL Not Like Statement not working

I have the following code within a stored procedure. WHERE WPP.ACCEPTED = 1 AND WPI.EMAIL LIKE '%@MATH.UCLA.EDU%…

sql where sql-like

DISTINCT clause with WHERE

How can I use the DISTINCT clause with WHERE? For example: SELECT * FROM table WHERE DISTINCT email; -- email is …

sql distinct where

PHP MySQL Query Where x = $variable

I have this code (I know that the email is defined) <?php $con=mysqli_connect($host,$user,$pass,$database); …

php mysql variables where

SQLSTATE[42S22]: Column not found: 1054 Unknown column - Laravel

I'm using the framework Laravel. I have 2 tables (Users and Members). When I want to login, I get the error …

php sql laravel where where-clause

SQL : BETWEEN vs <= and >=

In SQL Server 2000 and 2005: what is the difference between these two WHERE clauses? which one I should use on which …

sql sql-server tsql where between