Advanced Search

Return to Snippet

Revision: 11185
at January 27, 2009 15:16 by xtheonex
Initial Code 
SELECT * FROM `table` ORDER BY rand() LIMIT 1
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This is by no means the most efficient way to do this, in terms of performance.
It is however the easiest way.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Select random row from a SQL database.

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql, sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL