RE: Hmm looks like this query works

3 21:36 To: Dathan Vance Pattishall; [EMAIL PROTECTED] Subject: RE: Hmm looks like this query works I think your query will just return the first 10 values in the table sorted in random order due to how MySQL handles queries that use ORDER BY and LIMIT: [from mysql documentation] If you use LI

RE: Hmm looks like this query works

Try this instead... SELECT val_column, 0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit 10; Cheers, A -Original Message- From: Eric Wagner [mailto:[EMAIL PROTECTED] Sent: Tuesday 10 June 2003 21:36 To: Dathan Vance Pattishall; [EMAIL PROTECTED] Subject: RE: Hmm looks like

RE: Hmm looks like this query works

sorting the whole table http://www.mysql.com/doc/en/LIMIT_optimisation.html > -Original Message- > From: Dathan Vance Pattishall [mailto:[EMAIL PROTECTED] > Sent: Tuesday, June 10, 2003 11:19 AM > To: [EMAIL PROTECTED] > Subject: Hmm looks like this query works > >

RE: Hmm looks like this query works

hieve the same result with 1 row. -->-Original Message- -->From: Becoming Digital [mailto:[EMAIL PROTECTED] -->Sent: Tuesday, June 10, 2003 11:33 AM -->To: [EMAIL PROTECTED] -->Subject: Re: Hmm looks like this query works --> -->What's your end goal, and for what

Re: Hmm looks like this query works

Pattishall" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, 10 June, 2003 14:19 Subject: Hmm looks like this query works I have a question. If I wanted to sort randomly on a column weighted by the value of the column will does this query work SELECT val_column, val_column*0.

Hmm looks like this query works

I have a question. If I wanted to sort randomly on a column weighted by the value of the column will does this query work SELECT val_column, val_column*0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit 10; This should five me a random row weighted by the value of the column is this corr

RE: hmm

I missed the original question but here is my two cents. The solution has to do with how you define "... used as a online database". Steve Rapaport is correct if you want to create a database accessable via a browser, but if you just want a database available on the net all you need (on the se

RE: hmm

By the way you're using the terms, I would guess you're hoping to make a new database, and place it "on the web". In that case, Mysql is probably at too low a level of detail for your needs. To solve your problem you would need to learn: HTML CGI middleware (ASP, PHP, etc) MySQL SQL database

RE: hmm

* Harry Rorarius > I thought Mysql was a server that could be used as a online database? Yes, it is... > If it is, is there some material I have not read that tells me how to do > this? Probably :o) > I understood most of the information I read about Mysql. I was under the > understanding sql

RE: hmm

Harry, It is you need to make a WEB front end to access it -Original Message- From: Harry Rorarius [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 28, 2002 10:49 AM To: Mysql list Subject: hmm ok I thought Mysql was a server that could be used as a online database? If it is, is

Re: hmm

On Thursday 28 March 2002 9:48 am, Harry Rorarius wrote: > I thought Mysql was a server that could be used as a online database? Yes > If it is, is there some material I have not read that tells me how to do > this? What are you trying to do? You have not been at all clear in y

hmm

ok I thought Mysql was a server that could be used as a online database? If it is, is there some material I have not read that tells me how to do this? I understood most of the information I read about Mysql. I was under the understanding sql is the way to make a online database Harry ---