Top "Where-clause" questions

SQL - HAVING vs. WHERE

I have the following two tables: 1. Lecturers (LectID, Fname, Lname, degree). 2. Lecturers_Specialization (LectID, Expertise). I want to find the …

sql where-clause having

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

MySql Inner Join with WHERE clause

Here is my code: SELECT table1.f_id FROM table1 WHERE table1.f_com_id = '430' AND table1.f_…

mysql sql where-clause mysql-error-1064

Conditional WHERE clause with CASE statement in Oracle

I'm brand-new to the Oracle world so this could be a softball. In working with an SSRS report, I'm passing …

sql oracle where-clause

LINQ Where with AND OR condition

So I have managed to get this query working List<string> listStatus = new List<string>() ; listStatus.…

linq linq-to-sql where-clause

SQL Server : check if variable is Empty or NULL for WHERE clause

When searching for a list of products, the @SearchType parameter is optional. If @SearchType is empty or NULL then it …

sql sql-server if-statement where-clause

Conditional WHERE clause in SQL Server

I am creating a SQL query in which I need a conditional where clause. It should be something like this: …

sql sql-server sql-server-2008 tsql where-clause

SQL server ignore case in a where expression

How do I construct a SQL query (MS SQL Server) where the "where" clause is case-insensitive? SELECT * FROM myTable WHERE …

sql sql-server where-clause case-insensitive

Laravel where on relationship object

I'm developing a web API with Laravel 5.0 but I'm not sure about a specific query I'm trying to build. My …

php laravel eloquent relationship where-clause

CodeIgniter: How to use WHERE clause and OR clause

I am using the following code to select from a MySQL database with a Code Igniter webapp: $query = $this->…

mysql select codeigniter where-clause