Are the techniques used in the following query new discoveries?
$result=mysql_query(" select ProductSerNo from Products where (@pos:=locate(concat('#',ProductSerNo,'#'),'#12#10#1#9#'))!=0 order by @pos ");
(@pos is a user variable, ProductSerNo is an auto_increment column of Products table, '#12#10#1#9#' represents stored serial Nos of certain Products)
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
