A COMPARATIVE ANALYSIS OF THE USE OF REGEXP AND LIKE OPERATOR IN MYSQL

Abstract

This research paper compares the performance of RegExp and LIKE operators in MySQL for searching text data. Research shows which of these two techniques provides better search performance and efficiency. The paper includes an overview of RegExp and LIKE operators, their syntax and characteristics. The research methodology includes the definition of test scenarios, the selection of test data and the implementation of the experimental environment. Parameters considered include execution time as well as implementation complexity. Analysis of the results includes comparing the advantages, disadvantages and functionality of both approaches. Different test scenarios were tested on databases of ten thousand, one hundred thousand and one million rows of user data, in order to evaluate how the number of data being searched affects execution times. The aim of the research is to provide guidelines for choosing the most efficient tool for searching textual data in MySQL. The results of this research will be useful to developers in making decisions about the selection of textual data search tools.