Random like order with mysql and PHP : <p>I use PHP and Mysql. I have a table that looks kind of like this:</p>

<pre><code>id   title
----------
1    my title
2    another title
3    The last title
</code></pre>

<p>Now I want to select them with a random like order.</p>

<ul>
<li>I will need to use LIMIT because of the query size.</li>
<li>The random like order should always be the same random order every time.</li>
</ul>

<h2>Example result, every time</h2>

<pre><code>3   The last title
1   my title
2   another title
</code></pre>

<p>Do another query run:</p>

<pre><code>3   The last title
1   my title
2   another title
</code></pre>

<p>The same random like result appear.</p>

<h2>Possible solutions</h2>

<ul>
<li>Add a real random number stored as a new column generated by insert.</li>
<li>Some fancy SELECT query that does some magic.</li>
<li>Something else?</li>
</ul>

<p>Why I want this is that I insert products, first from one site, then from another. In the result I want to present them as a mix.</p>
