MySQL – SET Table of content The MySQL SET data type The MySQL SET data type is used to store a set of values chosen from a predefined list of values. Each column of the SET datatype can have zero or more values chosen from its list of values. These values are specified as a […]
Category Archives: mysql
MySQL – Regular Expressions Table of content MySQL supports various types of pattern matching operations to retrieve filtered result-sets from huge database tables. In previous chapters, we have already learned about the LIKE operator for pattern matching. In this chapter, we will see another pattern matching operation based on regular expressions. MySQL Regular Expressions A […]
MySQL – RLIKE Operator Table of content MySQL RLIKE Operator The RLIKE operator in MySQL is used to search data in a database using patterns (or regular expressions), also known as pattern matching. In other words, the RLIKE operator is used to determine whether a given regular expression matches a record in a table or […]