MySQL - NOT LIKE 運算子

要使用 Node.js 程式查詢 MySQL 資料庫中不匹配特定模式的資料，可以使用 Not Like 運算子。為此，我們需要使用mysql2 庫的query() 函式執行 'SELECT' 語句，如下所示：

sql = "SELECT * FROM tutorials_tbl where tutorial_author Not like 'Jo%'";
con.query(sql);

要使用 Java 程式查詢 MySQL 資料庫中不匹配特定模式的資料，可以使用 Not Like 運算子。為此，我們需要使用JDBC 函式executeUpdate()執行 'SELECT' 語句，如下所示：

String sql = "SELECT * FROM EMP where Name NOT LIKE 'Su%'";
statement.executeQuery(sql);

要使用 Python 程式查詢 MySQL 資料庫中不匹配特定模式的資料，可以使用 Not Like 運算子。為此，我們需要使用 MySQL Connector/Python 的execute() 函式執行 'SELECT' 語句，如下所示：

sql = "SELECT * FROM EMP where Name NOT LIKE 'Su%'"    
cursorObj.execute(sql)

var mysql = require('mysql2');
var con = mysql.createConnection({
host:"localhost",
user:"root",
password:"password"
});
 //Connecting to MySQL
 con.connect(function(err) {
 if (err) throw err;
  //console.log("Connected successfully...!");
  //console.log("--------------------------");
 sql = "USE TUTORIALS";
 con.query(sql);
 sql = "SELECT * FROM tutorials_tbl where tutorial_author Not like 'Jo%'";
 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:
[
  {
    tutorial_id: 2,
    tutorial_title: 'Angular Java',
    tutorial_author: 'Abdul S',
    submission_date: 2023-08-07T18:30:00.000Z
  },
  {
    tutorial_id: 3,
    tutorial_title: 'Learning Java',
    tutorial_author: 'Sanjay',
    submission_date: 2007-05-05T18:30:00.000Z
  },
  {
    tutorial_id: 4,
    tutorial_title: 'Python Tutorial',
    tutorial_author: 'Sasha Lee',
    submission_date: 2016-09-03T18:30:00.000Z
  },
  {
    tutorial_id: 5,
    tutorial_title: 'Hadoop Tutorial',
    tutorial_author: 'Chris Welsh',
    submission_date: 2023-08-07T18:30:00.000Z
  }
]

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class NotLikeOperator {
   public static void main(String[] args) {
      String url = "jdbc:mysql://: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 * FROM EMP where Name NOT LIKE 'Su%'";
            rs = st.executeQuery(sql);
            System.out.println("Table records: ");
            while(rs.next()) {
               String id = rs.getString("id");
               String name = rs.getString("Name");
               String dob = rs.getString("dob");
               String location = rs.getString("location");
               System.out.println("Id: " + id + ", Name: " + name + ", Dob: " + dob + ", Location: " + location);
            }
      }catch(Exception e) {
         e.printStackTrace();
      }
   }
}      

輸出

獲得的輸出如下所示：

Table records: 
Id: 101, Name: Amit, Dob: 1970-01-08, Location: Hyderabad
Id: MyID2, Name: Raja, Dob: 1980-11-06, Location: Goa
Id: MyID2, Name: Raja, Dob: 1980-11-06, Location: Goa
Id: 109, Name: Javed, Dob: 1980-11-06, Location: pune
Id: 120, Name: Vani, Dob: 1980-11-06, Location: Delhi
Id: oo1, Name: Devi, Dob: 1980-11-06, Location: Goa

import mysql.connector
#establishing the connection
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
#Creating a cursor object 
cursorObj = connection.cursor()
notlike_operator_query = f"SELECT * FROM EMP where Name NOT LIKE 'Su%'"
cursorObj.execute(notlike_operator_query)
# Fetching all the results
results = cursorObj.fetchall()
# display the results
print("Employees whose name does not start with 'Su':")
for row in results:
    print(row)
cursorObj.close()
connection.close()      

輸出

以下是上述程式碼的輸出：

Employees whose name does not start with 'Su':
('101', 'Amit', datetime.date(1970, 1, 8), 'Hyderabad')
('MyID2', 'Raja', datetime.date(1980, 11, 6), 'Goa')
('109', 'Javed', datetime.date(1980, 11, 6), 'pune')
('120', 'Vani', datetime.date(1980, 11, 6), 'Delhi')
('oo1', 'Devi', datetime.date(1980, 11, 6), 'Goa')