MySQL Random Sort

ibatis_MySQLRandomSort.sql

	SELECT 
	a.value AS x, b.value AS y
	FROM 
	$table$ a
	LEFT JOIN  $table$ b ON (a.id = b.id)
	WHERE a.category = #categoryA#
	AND b.category = #categoryB# 

ibatis_MySQLRandomSort.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="snippet">
	<select id="snippetRandomSort">
	SELECT 
	a.value AS x, b.value AS y
	FROM 
	$table$ a
	LEFT JOIN  $table$ b ON (a.id = b.id)
	WHERE a.category = #categoryA#
	AND b.category = #categoryB# 
	<!-- point:'ORDER BY rand()' -->
	<isNotEqual property="dataLimit" compareValue="-1"> ORDER BY rand() LIMIT #dataLimit#</isNotEqual>
	</select>
</sqlMap>