MySQL - RLIKE 运算符

要通过 Node.js 程序使用模式或正则表达式从 MySQL 数据库中搜索数据，我们需要使用 mysql2 库中的 query() 函数执行以下"SELECT"语句，如下所示:-

sql = "SELECT * FROM person_tbl WHERE NAME RLIKE 'sh$'";
con.query(sql);

要通过 Java 程序使用模式或正则表达式从 MySQL 数据库中搜索数据，我们需要使用 JDBC 函数 executeUpdate() 执行以下"SELECT"语句，如下所示:-

String sql = "SELECT NAME FROM person_tbl WHERE NAME RLIKE '^sa'";
statement.executeQuery(sql);

要通过 Python 程序使用模式或正则表达式从 MySQL 数据库中搜索数据，我们需要使用 MySQL Connector/Python 的 execute() 函数执行以下"SELECT"语句，如下所示:-

sql = 'SELECT NAME FROM person_tbl WHERE NAME RLIKE '^sa''
cursorObj.execute(sql)

var mysql = require('mysql2');
var con = mysql.createConnection({
host:"localhost",
user:"root",
password:"password"
});
//连接到 MySQL
 con.connect(function(err) {
 if (err) throw err;
  //console.log("Connected successfully...!");
  //console.log("--------------------------");
 sql = "USE TUTORIALS";
 con.query(sql);
 sql = "SELECT * FROM person_tbl WHERE NAME RLIKE 'sh$'";
 console.log("Select query executed successfully..!");
 console.log("Table records: ");
 con.query(sql);
 con.query(sql, function(err, result){
 if (err) throw err;
 console.log(result);
 });
});    

输出

生成的输出如下 -

Select query executed successfully..!
Table records:
[
  { ID: 3, NAME: 'Santosh', AGE: 34, ADDRESS: 'Hyderabad' },
  { ID: 6, NAME: 'Ramesh', AGE: 40, ADDRESS: 'Mumbai' }
]

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class RlikeOperator {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/TUTORIALS";
        String user = "root";
        String password = "password";
        ResultSet rs;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, user, password);
            Statement st = con.createStatement();
            //System.out.println("Database connected successfully...!");
            String sql = "SELECT NAME FROM person_tbl WHERE NAME RLIKE '^sa'";
            rs = st.executeQuery(sql);
            System.out.println("Table records: ");
            while(rs.next()) {
                String name = rs.getString("Name");
                System.out.println("Name: " + name);
            }
        }catch(Exception e) {
            e.printStackTrace();
        }
    }
}    

输出

获得的输出如下所示 -

Table records: 
Name: Santosh

import mysql.connector
#建立连接
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
#创建游标对象
cursorObj = connection.cursor()
rlike_operator_query = f"SELECT NAME FROM person_tbl WHERE NAME RLIKE '^sa'"
cursorObj.execute(rlike_operator_query)
result = cursorObj.fetchall()
print("Names that start with 'sa':")
for row in result:
    print(row[0])
cursorObj.close()
connection.close()    

输出

以下是上述代码的输出 -

Names that start with 'sa':
Santosh