small query prob in Mysql
| From: | Sagar C Nannapaneni | Date: | Tue, 14 Sep 2004 04:31:48 +0000 |
| Subject: | small query prob in Mysql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-196590@lists.php.net to get a copy of this message | ||
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....
Thanks in advance,
/sagar