MySQL – REGEXP_REPLACE() Function Table of content Regular expressions in MySQL are used in search operations to not only filter records but also replace the pattern occurrences in a string. Consider a scenario where you noticed a spelling error among the huge sets of data present in a MySQL database. Now, you are supposed to […]
Category Archives: mysql
MySQL – ENUM Table of content ENUM (Enumerator) is a user defined datatype which stores a list of values as strings. These values are specified when you define the ENUM column. The user can choose values from this predefined list while inserting values into this column. Each string value defined in an ENUM column is […]
MySQL – DECIMAL Table of content The MySQL Decimal Data Type The MySQL DECIMAL data type is used to store numeric values with decimal points. It allows for precise calculations and can be configured to store a specified number of digits before and after the decimal point. We often use this datatype for the columns […]