MySQL – Wildcards Table of content The MySQL wildcards The MySQL wildcards are special characters used in combination with the LIKE operator to search for text patterns in a table column. MySQL provides two wildcards: percent (%) and underscore (_). The following table mentions the use case of the two wildcards in MySQL − S.NO […]
Category Archives: mysql
MySQL – EXPLAIN Table of content The MySQL EXPLAIN Statement The MySQL EXPLAIN statement is used to provide the execution plan of a query. This statement works similar to the DESCRIBE query; while the DESCRIBE query provides the structure plan of a table, the EXPLAIN statement describes how a query is being executed. You can […]
MySQL – Today Date Table of content Generally, the date is represented using three values: date, month, and year. Dates have many possible variations, all of which depend on several inconsistency factors. DD/MM/YYYY, For instance – 04/04/2024 YYYY/MM/DD, For instance – 2024/04/27 DD-MM-YYYY, For instance – 04-04-2024 MySQL Today”s Date We have several built-in functions […]