Query to show data but ignore dupes

#1

i have a database with 500,000 records.

one column has the same data over and over. i am trying to get a list of
the differnt names in that one column but cant get it to ignore the
duplicates

can anyone help me with this query as i cant work out how to use WHERE store
= different

SELECT * FROM datasearch WHERE store LIKE '%'

thank you in advance to anyone that can help me.
andy

#2

Andrew wrote:

Quote:

i have a database with 500,000 records.

one column has the same data over and over. i am trying to get a list of
the differnt names in that one column but cant get it to ignore the
duplicates

can anyone help me with this query as i cant work out how to use WHERE store
= different

SELECT * FROM datasearch WHERE store LIKE '%'

thank you in advance to anyone that can help me.
andy

http://dev.mysql.com/doc/refman/5.0/en/select.html

#3

"strawberry" <zac.carey (AT) gmail (DOT) com> wrote

Quote:

Andrew wrote:
i have a database with 500,000 records.

one column has the same data over and over. i am trying to get a list of
the differnt names in that one column but cant get it to ignore the
duplicates

can anyone help me with this query as i cant work out how to use WHERE
store
= different

SELECT * FROM datasearch WHERE store LIKE '%'

thank you in advance to anyone that can help me.
andy

http://dev.mysql.com/doc/refman/5.0/en/select.html

Already read that webpage but thank you for the link.

http://www.microsoft.com

#4

Andrew wrote:

Quote:

"strawberry" <zac.carey (AT) gmail (DOT) com> wrote in message
news:1155138216.458419.99950 (AT) 75g2000cwc (DOT) googlegroups.com...

Andrew wrote:
i have a database with 500,000 records.

one column has the same data over and over. i am trying to get a list of
the differnt names in that one column but cant get it to ignore the
duplicates

can anyone help me with this query as i cant work out how to use WHERE
store
= different

SELECT * FROM datasearch WHERE store LIKE '%'

thank you in advance to anyone that can help me.
andy

http://dev.mysql.com/doc/refman/5.0/en/select.html

Already read that webpage but thank you for the link.

http://www.microsoft.com

I think in that case you should read it again!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Query to show data but ignore dupes

comp.databases.mysql comp.databases.mysql

Query to show data but ignore dupes - 08-09-2006 , 10:05 AM

Re: Query to show data but ignore dupes - 08-09-2006 , 10:43 AM

Re: Query to show data but ignore dupes - 08-09-2006 , 12:57 PM

Re: Query to show data but ignore dupes - 08-09-2006 , 01:51 PM