PHP Tutorials
- What is MySqli
- mysql query
- mysql query example
- InnoDB
- mysql column Type
- CRUD Example
- Connection Using Function
- mysql keys
- SELECT
- WHERE
- UPDATE
- Count no of Rows
- ALIAS
- AND, AND & OR
- BETWEEN
- COMPARISON OPERATOR
- DELETE
- DELETE LIMIT
- DISTINCT
- EXISTS
- FROM
- GROUP BY
- HAVING
- IN
- INTERSECT
- IS NULL & IS NOT NULL
- LIKE
- NOT
- ORDER BY
- SELECT LIMIT
- SUBQUERY
- TRUNCATE
- UNION && UNION ALL
- Concat & Group_Concat
- mysql Function
- Mysql Insert Id
- MySql Aggregate Function
- Mysql Join
- JOIN in MySql
- Trigger
- Procedure
- Transaction
- views
- Index
- SQL Injection
- Normalization
- Query Bind
- Interview Questions
Important Link
what is where clause in mysql?
The where clause is an optional clause used in MySQL statements. The WHERE clause is used to filter on the rows of the result set and return the rows by the FROM clause. It extracts only those records that fulfill the specified condition. The WHERE clause mainly depends upon a condition that evaluates as either be true, false. So, if you want to limit the number of rows to be affected by your DML statement (SELECT, INSERT, UPDATE, or DELETE), then you need to use the Where Clause in MySQL.
SELECT * FROM ittutorial WHERE course = 'php';
Select statement will return all the records from the ittutorial table whose course is php.
Where Clause Using AND and OR Condition.
SELECT * FROM ittutorial WHERE course = 'php' AND (author == 'sana mahtab' OR author == 'mahira mahtab');
UPDATE ittutorial SET author = 'Nusrat' WHERE course = 'php';
File Name :
File Name :
File Name :