Sponsored by NuSphere - PHP Software for PHP Application Developers - On Sale This Week for $100



Go Back   PHP-Editors > Linux, Apache, MySQL > MySQL Help

MySQL Help Post any question relating to MySQL here and hopefully someone can help

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 2005-02-10, 12:44 PM
Junior Member
 
Join Date: Nov 2004
Posts: 13
Deus_m1k3
Default

Hi:!

I'm tryin' to select from a table all the records but only the ones that aren't repited...

READ YA
Deus_m1k3
Reply With Quote
Sponsored Links
  #2 (permalink)  
Old 2005-02-10, 01:00 PM
Junior Member
 
Join Date: Nov 2004
Posts: 13
Deus_m1k3
Default

Oopps... 4got 2 tell ya that I need to select 3 columns that have a name and 2 last-names but I need that the query select the non repeated rows...

read ya
Deus_m1k3
Reply With Quote
  #3 (permalink)  
Old 2005-02-11, 10:56 AM
Junior Member
 
Join Date: Nov 2004
Posts: 13
Deus_m1k3
Default

JA!... sorry I 1st posted the message & then check a manual... LOL

SELECT DISTINCT first,second,third FROM table ORDER BY first;

read ya
Deus_m1k3
Reply With Quote
Must read Review for Serious PHP Developers


NuSphere PhpED 5.5 : The Staff of php-editors.com recently spent a few days working with NuSphere PhpED 5.5 (a popular PHP IDE) and NuCoder 2.0 (a PHP Encoding Utility), read up on all the details.

Sponsored Links
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -5. The time now is 11:10 PM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO 3.1.0
© Copyright 2003-2008 www.php-editors.com. The ultimate PHP Editor and PHP IDE site.