Generating unique random elements from MySQL by using rand()

Question

I am getting elements from MySQL by using this query;

select * from bahis where onay='1' or onay='2' order by rand()

But elements can be same with this query. For example I have 3 values that matches with this query, A,B,C

it can generate A A B or A B C or A B B

But I want to generate them like A B C or C B A or B A C.

How can I do that?

I think this is not your complete query. you may have a group by command — Mahoor13
– Mahoor13, Commented Aug 14, 2012 at 18:26

user149341 · Accepted Answer · 2012-08-14 18:42:59Z

1

As written, your query will not output any individual row more than once -- it will just return every row in a random order. If you're getting duplicates in the result, then your table must contain duplicates; if this is correct, and you just need to suppress them, use the DISTINCT modifier (e.g, SELECT DISTINCT * ...).

answered Aug 14, 2012 at 18:42

user149341

Sign up to request clarification or add additional context in comments.

Comments

Mahoor13 · Accepted Answer · 2012-08-14 18:37:09Z

1

use something like this

select * from 
(select * from bahis where onay='1' or onay='2' group by abc_field) s1
order by rand()

answered Aug 14, 2012 at 18:37

Mahoor13

5,6475 gold badges28 silver badges29 bronze badges

Collectives™ on Stack Overflow

Generating unique random elements from MySQL by using rand()

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related