24-03-2008, 09:17 PM
XyQrTw a écrit :heuu moi j'aurais ...
Code :SELECT `X`, `Y`, MAX(`X`) as X_Max, MAX(`Y`) as Y_Max, CAST(RAND() * X_Max AS UNSIGNED) as X_Rand, CAST(RAND() * Y_Max AS UNSIGNED) as Y_Rand FROM la_table WHERE 1 HAVING X <> X_Rand AND Y <> Y_Rand LIMIT 10;
Je pene que sa fonctionne ...
Bonjour,
Tu peux expilquer un peu ta requête ?
Merci