At 21:06 +0500 7/2/04, Muhammad Fayez Aziz wrote:
Are the techniques used in the following query new discoveries?
That's kind of a broad question. What techniques, specifically, are
you referring to?
$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)
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]