mysql 批量like

SELECT * FROM users WHERE name LIKE 'J%';

SELECT * FROM users WHERE name LIKE 'J%' OR name LIKE 'M%';

-- 创建索引
CREATE INDEX idx_name ON users(name);

-- 使用前缀匹配
SELECT * FROM users WHERE name LIKE 'J%';

-- 使用OR连接多个LIKE条件
SELECT * FROM users WHERE name LIKE 'J%' OR name LIKE 'M%';

-- 使用INSTR函数
SELECT * FROM users WHERE INSTR(name, 'J') = 1 OR INSTR(name, 'M') = 1;

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

-- 插入示例数据
INSERT INTO users (id, name) VALUES (1, 'John'), (2, 'Mary'), (3, 'Jack'), (4, 'Mike');

-- 查询名字以J或M开头的用户
SELECT * FROM users WHERE name LIKE 'J%' OR name LIKE 'M%';