mysql支持模糊查询

-- 创建一个示例表
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100)
);

-- 插入一些示例数据
INSERT INTO users (name, email) VALUES
('Alice', 'alice@example.com'),
('Bob', 'bob@example.com'),
('Charlie', 'charlie@example.com'),
('David', 'david@example.com');

-- 模糊查询示例：查找名字中包含'li'的用户
SELECT * FROM users WHERE name LIKE '%li%';

-- 创建全文索引
ALTER TABLE users ADD FULLTEXT(name);

-- 使用全文索引进行模糊查询
SELECT * FROM users WHERE MATCH(name) AGAINST('li');

<?php
$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 使用预处理语句
$stmt = $conn->prepare("SELECT * FROM users WHERE name LIKE ?");
$stmt->bind_param("s", $pattern);

$pattern = "%li%";
$stmt->execute();

$result = $stmt->get_result();
while ($row = $result->fetch_assoc()) {
    echo "ID: " . $row["id"] . " - Name: " . $row["name"] . " - Email: " . $row["email"] . "<br>";
}

$stmt->close();
$conn->close();
?>