在MySQL中的列之间随机引用

SELECT column1, column2, column3
FROM your_table
ORDER BY RAND()
LIMIT 1;

SELECT column1, column2, column3
FROM your_table
ORDER BY RAND()
LIMIT 5;

SELECT column1, column3
FROM your_table
ORDER BY RAND()
LIMIT 1;

SELECT column1, column2, column3
FROM (
    SELECT column1, column2, column3
    FROM your_table
    ORDER BY RAND()
    LIMIT 1000
) AS subquery
ORDER BY RAND()
LIMIT 1;

SELECT column1, column2, column3
FROM your_table TABLESAMPLE SYSTEM (10)
ORDER BY RAND()
LIMIT 1;

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

-- 插入一些示例数据
INSERT INTO example_table (name, age, city) VALUES
('Alice', 30, 'New York'),
('Bob', 25, 'Los Angeles'),
('Charlie', 35, 'Chicago'),
('David', 40, 'Houston');

-- 随机选择一条记录
SELECT name, city
FROM example_table
ORDER BY RAND()
LIMIT 1;