matching same words only once

[ghasem]

Greetings to all from the corner or Asia - guess where Iran!
Going directly to the point, I need to know how can we match a
pattern only once.
"SELECT exp01 FROM tblExp01 " will give me all the occurences of
exp01, my question is how can we see only non repeated occurences.
Example:
SELECT exp01 FROM tblExp01;

output of above query:
name1
name2
name1
name1
name2
name1
name3

I just want to see an output like:

name1
name2
name3

That there is an occurence, then select it, but if there was an
accurence donot select it again.

I hope I am not confusing you all , because I am not too good at
mySQL.
Thanks everyone.
ghasem

[usenet]

SELECT DISTINCT exp01 FROM tblExp01;
http://dev.mysql.com/doc/mysql/en/SELECT.html
On 10 Aug 2004 05:10:21 -0700, gh************@yahoo.com (ghasem) wrote:

Greetings to all from the corner or Asia - guess where Iran!
Going directly to the point, I need to know how can we match a
pattern only once.
"SELECT exp01 FROM tblExp01 " will give me all the occurences of
exp01, my question is how can we see only non repeated occurences.
Example:
SELECT exp01 FROM tblExp01;

output of above query:
name1
name2
name1
name1
name2
name1
name3

I just want to see an output like:

name1
name2
name3

That there is an occurence, then select it, but if there was an
accurence donot select it again.

I hope I am not confusing you all , because I am not too good at
mySQL.
Thanks everyone.
ghasem

[Jeff North]

On 10 Aug 2004 05:10:21 -0700, in mailing.database.mysql
gh************@yahoo.com (ghasem) wrote:

| Greetings to all from the corner or Asia - guess where Iran!
| Going directly to the point, I need to know how can we match a
| pattern only once.
| "SELECT exp01 FROM tblExp01 " will give me all the occurences of
| exp01, my question is how can we see only non repeated occurences.
| Example:
| SELECT exp01 FROM tblExp01;
|
| output of above query:
| name1
| name2
| name1
| name1
| name2
| name1
| name3
|
| I just want to see an output like:
|
| name1
| name2
| name3
|
| That there is an occurence, then select it, but if there was an
| accurence donot select it again.
|
| I hope I am not confusing you all , because I am not too good at
| mySQL.
| Thanks everyone.

SELECT exp01 FROM tblExp01 GROUP BY exp01;

[ghasem]

Thank you that was very helpful.
I tried it and gave exactly that answer I wanted. It is actually so
easy and basic but never came to me. Like I thought, I am not good at
SQL.
ghasem

Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<40********************************@4ax.com>. ..

On 10 Aug 2004 05:10:21 -0700, in mailing.database.mysql
gh************@yahoo.com (ghasem) wrote:

| Greetings to all from the corner or Asia - guess where Iran!
| Going directly to the point, I need to know how can we match a
| pattern only once.
| "SELECT exp01 FROM tblExp01 " will give me all the occurences of
| exp01, my question is how can we see only non repeated occurences.
| Example:
| SELECT exp01 FROM tblExp01;
|
| output of above query:
| name1
| name2
| name1
| name1
| name2
| name1
| name3
|
| I just want to see an output like:
|
| name1
| name2
| name3
|
| That there is an occurence, then select it, but if there was an
| accurence donot select it again.
|
| I hope I am not confusing you all , because I am not too good at
| mySQL.
| Thanks everyone.

SELECT exp01 FROM tblExp01 GROUP BY exp01;

[Jeff North]

On 10 Aug 2004 20:58:14 -0700, in mailing.database.mysql
gh************@yahoo.com (ghasem) wrote:

| Thank you that was very helpful.
| I tried it and gave exactly that answer I wanted. It is actually so
| easy and basic but never came to me. Like I thought, I am not good at
| SQL.
| ghasem
|
| > SELECT exp01 FROM tblExp01 GROUP BY exp01;

As someone else pointed out you could also use the SELECT DISTINCT
option.

SELECT DISTINCT exp01 FROM tblExp01;
http://dev.mysql.com/doc/mysql/en/SELECT.html
---------------------------------------------------------------
All I can say to the fundamentalist christians is:
BRING BACK THE LIONS BRING BACK THE LIONS
BRING BACK THE LIONS BRING BACK THE LIONS
BRING BACK THE LIONS BRING BACK THE LIONS

jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------

[ghasem]

That is also a eal great way, I think this is a more elegant way of
selecting the groups. I do't know of the performance differences
between "select distinct" and "select ........group by......" , I have
few records right now with the possibility of having few thousand
records.
ghasem
Jeff North <jn****@yourpantsbigpond.net.au> wrote in message news:<fe********************************@4ax.com>. ..

On 10 Aug 2004 20:58:14 -0700, in mailing.database.mysql
gh************@yahoo.com (ghasem) wrote:

| Thank you that was very helpful.
| I tried it and gave exactly that answer I wanted. It is actually so
| easy and basic but never came to me. Like I thought, I am not good at
| SQL.
| ghasem
|
| > SELECT exp01 FROM tblExp01 GROUP BY exp01;

As someone else pointed out you could also use the SELECT DISTINCT
option.

SELECT DISTINCT exp01 FROM tblExp01;
http://dev.mysql.com/doc/mysql/en/SELECT.html
---------------------------------------------------------------
All I can say to the fundamentalist christians is:
BRING BACK THE LIONS BRING BACK THE LIONS
BRING BACK THE LIONS BRING BACK THE LIONS
BRING BACK THE LIONS BRING BACK THE LIONS

jn******@yourpantsyahoo.com.au : Remove your pants to reply
---------------------------------------------------------------