thats exactly what i wanted - the perfekt solution, now i have to thing
about performance
but thanks to Shawn Green for trying to help :>
""Arnaud"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> > i have lets say 1000 different fruits
> > and 1000 different animals
> > with
fruit_id)
> SELECT (id_fruits, id_animals)
> FROM fruits_animals
>
> SELECT *
> FROM tmpDedupe
> ORDER BY RAND()
> LIMIT 100
>
> DROP TABLE tmpDedupe
>
> Make sense?
>
> Yours,
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce P
> B) You want a list of 100 un-duplicated random rows from the relationship
> table?
> - OR -
> C) Each time you run your query containing "ORDER BY RAND()" , you get the
> exact same set of records back?
>
> Yours,
> Shawn Green
> Database Administrator
> Unimi
i think its not even possible with subqueries
""Gerske, Sebastian"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> help me please :/
>
>
> ""Gerske, Sebastian"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
help me please :/
""Gerske, Sebastian"" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
> Hello list,
>
> i still need a solution for my 3 table join rand problem, im using version
> 4.1 now so subqueries are possible:
>
> explanati
Hello list,
i still need a solution for my 3 table join rand problem, im using version
4.1 now so subqueries are possible:
explanation:
i have 3 tables lets say:
fruits:
id, name
1banana
2apple
3strawberry
fruits_animals
id, id_fruits, id_animals
11 2
2
Hello list,
im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible.
Im having three tables which are joined by ID's now i want to select
a single row random out of the join set whats the best way to do it?
My Table structure is:
table1
Hello list,
im having a hughe problem with the RAND() function
first of all im using mysql 3.23 so subquerys are impossible.
table1
---
| id | content |
| 1 | apple |
---
relation_table
| id | id_table1 | id_table2 |
| 1 | 1
