3 names

[Forever_xxl]

In mysql i have(table):
ID | Name | type
1 | Audi | A6
2 | Audi | 100
3 | Audi | A8
4 | BMW | 318i
5 | BMW | 520i
6 | WV | Jeta
7 | WV | golf
8 | WV | pasat
9 | MAzda | MX-5
10 | mazda | 6
11 | mazda | 3
12 | Ford | mondeo
13 | Ford | GT 2
etc.

i want get 6 data, but show 3 difirents names (2 times bmw, 2 times wv, 2 times ford, all cars can't be same type (if are more in name cars type then 2 in get from rand()) )

I wan't what print: EX.:
WV | Jeta
WV | golf
MAzda | MX-5
mazda | 6
Ford | mondeo
Ford | GT 2

Please help. 😃. very need. If it possible how get it with mysql sentence.

[planetsim]

I assume english isnt your first language cos that was quite hard to understand.

I dont know how to do it in 1 Query to work the way you want it however you should really ask this in the Database forum as its more towards that than actual Coding.