- MySQL Limit
The LIMIT clause, as you might guess, is used to limit the number of rows returned in the result set. It has two parameters or arguments. The first parameter is offset which tells mysql how many rows to skip before starting to retrieve. The second parameter is count which tells mysql how many rows…
- MySQL Like
The LIKE operator is used to check if a string contains another string. These two wildcards are used with LIKE:1. “%” – check for a match of one or more characters2. “_” – check for a match of a single character If you are searching for something that ends with a certain pattern of […]
- MySQL Where
The WHERE clause is used in a SELECT statement with conditions to filter the result set. It is also used in the UPDATE and DELETE statement. There can be one or many conditions and a condition must be evaluated to true or false. A row must satisfy all conditions to be included in the […]
- MySQL Select
The SELECT statement is used to read or retrieve rows(data) from one or more database tables or views. You can retrieve one, two, or three, or all columns depending on what you need. Each row you retrieve will have the same number of columns. Here is an example of a SELECT statement. Select…
- MySQL Delete
To delete data from a table, DELETE statement is used. Once data is deleted from your tables you can’t recover it. It is gone. It is recommended to back up your database regularly so that if data is gone you can still recover it from your backups. The WHERE clause is optional but if […]