สอบถามเรื่องการตรวจเลขซ้ำใน sql หน่อย พอดีจะเลือกชุดตัวเลขที่มีตัวเลขข้างในชุดที่เหมือนกันด้วยไม่สนตำแหน่งมีรูปประกอบ

<?php
function m ($x) {
	$a=array();
	for($i=0; $i<3; $i++) $a[]=substr($x[0],$i,1);
	sort($a)
	return implode('', $a);
}
function cv($input) {
 	return preg_replace_callback( '/[0-9]{3}/', m , $input );
}
$data = '124 214 421 112 211 535 779 335 533 114 141 452 524';
print_r(array_unique( explode(' ', cv($data))));
?>

$a=array();
$ar=array()
while( $ro=$rs->fetch_assoc()){
	for($i=0; $i<3; $i++) $a[]=substr($ro['num_data'],$i,1);
	$ar[]=implode('', $a);
}
print_r(array_unique( $ar));

"SELECT nuber_new, SUM(tot_up_price) AS tot_up_price FROM lottery
where (select_new = 'เลข3ตัว') and (tot_up_price > 0) 
GROUP by nuber_new HAVING SUM(tot_up_price)  > $chk1
ORDER BY tot_up_price DESC"

<? 
$chk1=$_POST[textfield];
$chk2=$_POST[textfield2];
$chk1=$chk1+0;
$chk2=$chk2+0;
include "../connect.php"; 
$strSQL = "SELECT nuber_new, SUM(tot_up_price) AS tot_up_price FROM lottery
where (select_new = 'เลข3ตัว') and (tot_up_price > 0) 
GROUP by nuber_new HAVING SUM(tot_up_price)  > $chk1
ORDER BY tot_up_price DESC";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
?>
<table width="350" border="1" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="3" align="center" valign="middle" bgcolor="#FFFFFF"><strong>โต๊ดหัว 
        <input type="submit" name="Submit" value="พิมพ์" onclick="javascript:this.style.display='none';window.print()" />
    </strong></td>
  </tr>
  <tr>
    <td width="50" align="center" valign="middle" bgcolor="#CCFFFF">ลำดับ</td>
    <td width="51" align="center" valign="middle" bgcolor="#CCFFFF">เลข</td>
    <td width="117" align="center" valign="middle" bgcolor="#CCFFFF">ราคา</td>
  </tr>
   <?
while($objResult = mysql_fetch_array($objQuery))
{
?>
  <tr>
    <td align="center" valign="middle"><?php echo ++$i; ?></td>
    <td align="center" valign="middle"><?
	$a=array();
	$ar=array();
	//while( $ro=$rs->fetch_assoc()){
		for($i=0; $i<3; $i++) $a[]=substr($objResult['nuber_new'],$i,1);
		$ar[]=implode('', $a);
	//}
	print_r(array_unique( $ar));
	
	
	?></td>
    <td align="right" valign="middle"><?=$objResult["tot_up_price"]-$chk2;?>
    &nbsp;&nbsp;</td>
  </tr>
   <?
}
?>

$strSQL = <<<SQL
SELECT nuber_new, SUM(tot_up_price) AS ttl
FROM (
	select * ,  group_concat( a ) as ga from ( 
		select * from (
			SELECT *, LEFT(select_new,1) as a FROM `lottery` union all
			SELECT *, SUBSTRING(select_new,2, 1) as a FROM `lottery` union all
			SELECT *, RIGHT(select_new,1) FROM `lottery`
		) as t order by a
	) as t1 group by no_data # ดู no_data ให้ดีนะครับ ผมว่าไม่ได้เอา ฟีลด์จริง มาให้ผม แค่สร้าง ตัวอย่างมาใช่ไหมครับ
) as t2 GROUP BY by ga
HAVING ttl  > $chk1
ORDER BY ttl DESC
SQL;

<? 
$chk1=$_POST[textfield];
$chk2=$_POST[textfield2];
$chk1=$chk1+0;
$chk2=$chk2+0;
include "../connect.php"; 


$strSQL = "SELECT nuber_new, SUM(tot_up_price) AS tot_up_price
FROM ( select * , group_concat( a ) as ga from (
select * from (
SELECT *, LEFT(select_new,1) as a FROM `lottery` union all
SELECT *, SUBSTRING(select_new,2, 1) as a FROM `lottery` union all
SELECT *, RIGHT(select_new,1) FROM `lottery`
) as t order by a
) as t1 group by no_data
) as t2 GROUP BY by ga
HAVING tot_up_price  > $chk1
ORDER BY tot_up_price DESC"


;

$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");


?>

<table width="350" border="1" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td colspan="3" align="center" valign="middle" bgcolor="#FFFFFF"><strong>โต๊ด 
        <input type="submit" name="Submit" value="พิมพ์" onclick="javascript:this.style.display='none';window.print()" />
    </strong></td>
  </tr>
  <tr>
    <td width="50" align="center" valign="middle" bgcolor="#CCFFFF">ลำดับ</td>
    <td width="51" align="center" valign="middle" bgcolor="#CCFFFF">เลข</td>
    <td width="117" align="center" valign="middle" bgcolor="#CCFFFF">ราคา</td>
  </tr>
   <?
while($objResult = mysql_fetch_array($objQuery))
{
?>
  <tr>
    <td align="center" valign="middle"><?php echo ++$i; ?></td>
    <td align="center" valign="middle"><?
	$a=array();
	$ar=array();
	//while( $ro=$rs->fetch_assoc()){
		for($i=0; $i<3; $i++) $a[]=substr($objResult['nuber_new'],$i,1);
		$ar[]=implode('', $a);
	//}
	print_r(array_unique( $ar));
	
	
	?></td>
    <td align="right" valign="middle"><?=$objResult["tot_up_price"]-$chk2;?>
    &nbsp;&nbsp;</td>
  </tr>
   <?
}
?>

DELIMITER $$
CREATE FUNCTION sort_num_3 (num char(3))
RETURNS char(3) DETERMINISTIC
BEGIN
	DECLARE v_finished INTEGER DEFAULT 0;
	DECLARE v_num varchar(3) DEFAULT "";
	DECLARE rs_num varchar(3) DEFAULT "";
	DEClARE num_cursor CURSOR FOR 
		SELECT A FROM (
			SELECT LEFT(num,1) A union all
			SELECT SUBSTRING(num,2,1) union all
			SELECT RIGHT(num,1)
		) T ORDER BY A;
	DECLARE CONTINUE HANDLER 
		FOR NOT FOUND SET v_finished = 1;
	OPEN num_cursor;
		get_num: LOOP
			FETCH num_cursor INTO v_num;
			IF v_finished = 1 THEN 
				LEAVE get_num;
			END IF;
			SET rs_num = CONCAT(rs_num, v_num );
		END LOOP get_num;
	CLOSE num_cursor;
	RETURN rs_num;
END$$
DELIMITER ;

$strSQL = "SELECT ga, SUM(tot_up_price) AS tot_up_price
FROM ( 
	select tot_up_price , sort_num_3( nuber_new) as ga 
	FROM lottery
) as t
GROUP BY ga
HAVING tot_up_price  > $chk1
ORDER BY SUM(tot_up_price) DESC"

select nuber_new, sum(tot) tot_up_price, sort_num from (
SELECT nuber_new, tot_up_price tot,
IF( 
	LEFT(nuber_new, 1)<SUBSTRING(nuber_new, 2,1) 
	, IF(
		SUBSTRING(nuber_new, 2,1)<RIGHT(nuber_new, 1) 
		,  nuber_new   #123
		,  IF(
			LEFT( nuber_new, 1) < RIGHT( nuber_new, 1)
			, CONCAT(LEFT(nuber_new,1),RIGHT(nuber_new,1),SUBSTRING(nuber_new, 2,1) )  #132
			, CONCAT(RIGHT(nuber_new,1),LEFT(nuber_new,2) )  #231
		)
	)
	, IF(
		SUBSTRING(nuber_new, 2,1)>RIGHT(nuber_new,1)
		,  CONCAT(RIGHT(nuber_new,1),SUBSTRING(nuber_new, 2,1),LEFT(nuber_new,1) )  #321
		,  IF(
			LEFT( nuber_new , 1)<RIGHT( nuber_new, 1)
			, CONCAT(SUBSTRING(nuber_new, 2,1),LEFT(nuber_new,1),RIGHT(nuber_new,1) ) #213
			, CONCAT(RIGHT(nuber_new,2),LEFT(nuber_new, 1) ) #312
		)
	)
) sort_num
FROM `lottery`
)as t group by sort_num