Professional Web Applications Themes

Query to show data but ignore dupes - MySQL

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...

  1. #1

    Default Query to show data but ignore dupes

    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



    Andrew Guest

  2. #2

    Default Re: Query to show data but ignore dupes


    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
    [url]http://dev.mysql.com/doc/refman/5.0/en/select.html[/url]

    strawberry Guest

  3. #3

    Default Re: Query to show data but ignore dupes


    "strawberry" <zac.carey> wrote in message
    news:1155138216.458419.9995075g2000cwc.googlegrou ps.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
    >
    > [url]http://dev.mysql.com/doc/refman/5.0/en/select.html[/url]
    >
    Already read that webpage but thank you for the link.

    [url]http://www.microsoft.com[/url]


    Andrew Guest

  4. #4

    Default Re: Query to show data but ignore dupes


    Andrew wrote:
    > "strawberry" <zac.carey> wrote in message
    > news:1155138216.458419.9995075g2000cwc.googlegrou ps.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
    > >
    > > [url]http://dev.mysql.com/doc/refman/5.0/en/select.html[/url]
    > >
    >
    > Already read that webpage but thank you for the link.
    >
    > [url]http://www.microsoft.com[/url]
    I think in that case you should read it again!

    strawberry Guest

Similar Threads

  1. How to find nested dupes
    By Jaak in forum MySQL
    Replies: 5
    Last Post: January 24th, 01:47 AM
  2. Datagrid don't show all values from query
    By jorge_sms in forum Macromedia Flex General Discussion
    Replies: 1
    Last Post: September 19th, 03:31 PM
  3. Replies: 1
    Last Post: March 25th, 12:41 PM
  4. Query results don't display properly in results table.IGNORE PREVIOUS
    By JoyRose in forum Coldfusion - Advanced Techniques
    Replies: 1
    Last Post: March 24th, 07:28 PM
  5. Entering Data and then having another linked data show up.
    By Jennifer Van Pelt in forum Microsoft Access
    Replies: 2
    Last Post: July 16th, 06:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139