Search found 4 matches
- Wed Apr 30, 2008 6:04 am
- Forum: Databases
- Topic: small query problem
- Replies: 7
- Views: 697
Re: small query problem
nothing, I have a very little experience with mysql/sql I'm kinda shooting in the dark here...
- Wed Apr 30, 2008 4:17 am
- Forum: Databases
- Topic: small query problem
- Replies: 7
- Views: 697
Re: small query problem
this means I will have to query the db several times, or the union will connect everything?
- Wed Apr 30, 2008 3:49 am
- Forum: Databases
- Topic: small query problem
- Replies: 7
- Views: 697
Re: small query problem
what if I don't need it shuffled, only get x results with company=1, y results with company=2 and z results with company=3?
- Tue Apr 29, 2008 9:36 am
- Forum: Databases
- Topic: small query problem
- Replies: 7
- Views: 697
small query problem
Hi, I know it's a generic data, but it will help simplify the question: table with fields: ID (int, auto increment), name (varchar), price (int), company (int) lets assume there are around 300 rows in this table. company can be 1,2,3,4 is there a way to query the following: shuffle all the data and ...