Re: small query prob in Mysql
| From: | Curt Zirzow | Date: | Tue, 14 Sep 2004 05:37:30 +0000 |
| Subject: | Re: small query prob in Mysql | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-196591@lists.php.net to get a copy of this message | ||
* Thus wrote Sagar C Nannapaneni:
> Hi everybody,
>
> I'm having a database named "items", inthat
> one field name is "itemname" and the contents of
> that field is as follows....
>
> Monitor 15" - LG
> Monitor 17" - Samsung
> Keyboard - TVS
> Monitor 15" - Samsung
> Mouse - Genius
> Keyboard - Microsoft
> ....
> ....
> The first part is the component name and the second is the Company name
> I need to have the distinct components in this field...like this
>
> Monitor
> Keyboard
> Mouse
>
> Any help would b greatly appreciated....
In order to do that properly, you would need a normalized database,
a properly flattened data structure or hacked with some string
manipulation. Seek more help from a SQL or mysql list.
Curt
--
The above comments may offend you. flame at will.