Random & Exclude

[Chris_Evans]

Hi there,
I'd like to be able to do a random query, haven't quite figured this one yet but to make matters more complicated, I'd like to exclude something. ie:

mysql_query("SELECT RANDOM FROM database EXCLUDE name='$name'")

Obviously that is wrong, but that is what I'd like to do. All help is appreciated.

Thanks in advance 🙂,

Chris

[AstroTeg]

Random query on what? By your SQL definition, you're querying a field named "Random" from a table named "database"

To exclude something you could do:

... [SQL] ... WHERE [fieldname] NOT LIKE '$name'

or

... [SQL] ... WHERE [fieldname] <> '$name'
(this is more of an exact match and would be case sensitive)

or

... [SQL] ... WHERE [fieldname] != '$name'
(this is MySQL friendly)

Can we get more details on the field and how your want the random functionality to work?

[Chris_Evans]

Hi, thanks for the quick response. The random query simply needs to select a the a name from the field named 'name' radomly excluding the name (so confusing!) that has been entered.

Chris

[Weedpacket]

From the MySQL manual, the function is RAND(); you could order by RAND() and then the results will be in a random order.

[Chris_Evans]

Ok - thanks a lot for your help! 🙂