MySQL – Query Expansion Full-Text Search Table of content In relational databases like MySQL, Full-text search is a technique used to retrieve result-sets that might not perfectly match the search keyword. This type of search is useful in cases where the keywords used for searching do not match the results a user expects. So, this […]
Category Archives: mysql
MySQL – BLOB Table of content Many user applications require the storage of different types of data, including text, images, files, and more. Using BLOBs in a MySQL database allows you to store all these types of data within the same database, eliminating the need for a separate file system. The MySQL BLOB Data Type […]
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 […]