Regex usage in MongoDB
Background
Part1: Preface
Anyone who uses MySQL or other relational databases knows that fuzzy queries are used in similar ways:SELECT * FROM products WHERE sku like "% 789 ";
The regex in MongoDB described in this article
What is a regular expression?Regular expressions, also known as formal representations, general representations (English: Regular Expression, often abbreviated as regex, RegExp, or re) in code, are a concept of computer science. A regular expression
Before starting this topic, we should first conduct a small experiment to compare the high efficiency of REGEXP and Like. If the efficiency is too low, we do not need to do too much research, the experiment code is as follows:Require ("config. php ")
MySQL Download directory/usr/local/srcMySQL Extract directory/usr/local/bin/mysqlGitHub Https://github.com/mysql/mysql-serverInstallation instructions for MySQL websiteHttp://dev.mysql.com/doc/refman/5.6/en/source-installation.htmlRequired
mysql| Security | Security as a MySQL system administrator, you are responsible for maintaining the data security and integrity of your MySQL database system. This article mainly describes how to build a secure MySQL system, from the system internal
Use REGEXP Regular Expressions in MySQL.
In the past, I used like to search for data. Later I found that mysql also had regular expressions and felt better than like. Next I will share with you the Usage Details of mysql REGEXP regular expressions,
I used to find the data are using like later found in MySQL also have regular expressions and feel better than like, I would like to share with you the MySQL regexp regular expression use of detailed, I hope this method is helpful.
MySQL is
Abstract: This article describes in detail the principles of the MySQL permission system, including the complete process of MySQL Access confirmation. Another important knowledge is the user and host fields in the authorization table. Understanding
1. Why back up the database?
Backup is the most important and easy to ignore for databases. Unexpected events may cause serious losses.
The more important the data is, the more frequently the data changes, and the more frequently backup is
Apache is currently the most widely used Web server, PHP3 is an ASP-like scripting language, the current trend is much more than Perl, and MySQL is a lightweight database system, especially for Web site building, these 3 software are free software,
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.