how to excel comma file

how do i exract out of database

Page 1 of 1

5 Replies - 916 Views - Last Post: 09 July 2008 - 09:02 AM Rate Topic: -----

#1 rcnewbie  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 08-July 08

how to excel comma file

Post icon  Posted 08 July 2008 - 05:20 AM

how do i excract out of a data base of 50,000 emails i want to extract the ones that have 305 on the phone number
Is This A Good Question/Topic? 0
  • +

Replies To: how to excel comma file

#2 jjsaw5  Icon User is offline

  • I must break you
  • member icon

Reputation: 90
  • View blog
  • Posts: 3,060
  • Joined: 04-January 08

Re: how to excel comma file

Posted 08 July 2008 - 05:43 AM

View Postrcnewbie, on 8 Jul, 2008 - 08:20 AM, said:

how do i excract out of a data base of 50,000 emails i want to extract the ones that have 305 on the phone number



SELECT * FROM table_name
WHERE phone_number LIKE '305'


You could use something like this.
Was This Post Helpful? 0
  • +
  • -

#3 rcnewbie  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 08-July 08

Re: how to excel comma file

Posted 08 July 2008 - 07:54 AM

can you give the steps i am new to this.
thanks in advance.

i want to separate the 305 in a different database call it 305
Was This Post Helpful? 0
  • +
  • -

#4 PsychoCoder  Icon User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1642
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: how to excel comma file

Posted 08 July 2008 - 08:28 AM

[rules][/rules]
Was This Post Helpful? 0
  • +
  • -

#5 jjsaw5  Icon User is offline

  • I must break you
  • member icon

Reputation: 90
  • View blog
  • Posts: 3,060
  • Joined: 04-January 08

Re: how to excel comma file

Posted 09 July 2008 - 07:12 AM

I'm not going to do this project for you. You are going to need to learn and do it on your own. Then come back to us with your problems and we can help you work them out.

I would suggest doing some research on databases so you can get a good understanding of what is going to be involved with this.

My previous post was giving you a select statement that will pull out any phone number with 305, use that as a starting point.
Was This Post Helpful? 0
  • +
  • -

#6 Trogdor  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 15
  • View blog
  • Posts: 627
  • Joined: 06-October 06

Re: how to excel comma file

Posted 09 July 2008 - 09:02 AM

it should be LIKE '305%'
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1