- 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 […]
- MySQL Update
The UPDATE clause is used to update an existing row. It can be used to update a single row, a group of rows, or all rows within a table. How to use UPDATE1. Specify the tables you want to update.2. Set the column values to their new values.3. The WHERE clause is optional but […]