CODEWITHSUNDEEP
mysqlsql-limit
xylar
xylar

Reputation: 7673

Is it possible to do ORDER BY RAND() LIMIT but include the header?

Is it possible to return a random selection of rows from user table and include the header as the first row? The SQL I have at the moment just returns 5 random rows (not necessarily the header)

SELECT
    'id',
    'name'
UNION ALL SELECT
    id,
    name

INTO OUTFILE 'example.txt'
    FIELDS TERMINATED BY ' , ' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'

FROM
    users

ORDER BY RAND() LIMIT 5

Upvotes: 0

Views: 63

Answers (1)

Janaki
Janaki

Reputation: 291

Try this


SELECT 'id','name'
UNION ALL 
Select a.* from(
    SELECT id, name
    FROM  users
    ORDER BY RAND() LIMIT 5
 )a
INTO OUTFILE 'example.txt'  FIELDS TERMINATED BY ','  ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\r\n';

Upvotes: 2

Related Questions