Thank you!!!
It works.
Hector
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Monday, October 13, 2003 1:44 PM
To: Personal
Cc: [EMAIL PROTECTED]
Subject: Re: SELECT DISTINCT question
SELECT DISTINCT(LEFT (product_number,5)) FROM products.
http://www.mysql.com/doc/en/String_functions.html
hth
Jeff
Personal
<[EMAIL PROTECTED] To:
[EMAIL PROTECTED]
.net> cc:
Subject: SELECT DISTINCT
question
10/13/2003 12:38
PM
Hello everybody:
I have the following scenario:
I have a database of products, each of those products have a product
number
(like 04543000). Now the first five digits represent the product number,
and
the 2 following digits represent a differet color for the same product.
Now I have to show the thumbnails of this products but only for one color.
So my query should look something like this:
SELECT DISTINCT(product_number) FROM products.
Now this query will return all the different product numbers i.e. but it
will also return the different colors as a different product number.
Is there anyway to have a query like:
SELECT DISTINCT(first_five_product_numbers) FROM products?
I can find the solution to it. Maybe the solution will be more experience
:) But maybe the solution can be the list.
Thanks,
Hector
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
