MySQL – REGEXP_SUBSTR() Function Table of content Regular expressions in MySQL are used in search operations to filter and retrieve records from a database table that match specified patterns. This process of detecting patterns in a set of data is known as pattern matching. It is helpful whenever the data is considered to have similar […]
Category Archives: mysql
MySQL – Boolean Datatype Table of content A Boolean data type is used to represent truth values of logic and Boolean algebra. It has two possible values: either true or false. For example, if a customer wants to see all the bikes that are black in colour, we can filter them using BOOLEAN operator, as […]
MySQL – FLOAT Table of content The FLOAT data type is a part of the numeric data type. Numeric data types are used to store numbers, and they can be categorized into various subtypes based on their characteristics, such as storage size and precision. The MySQL FLOAT Data Type The MySQL FLOAT datatype is a […]