SQL

how to get names start from similar alphabet from database

Page 1 of 1

3 Replies - 1238 Views - Last Post: 08 October 2007 - 08:50 AM Rate Topic: -----

#1 Rg2005  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 9
  • Joined: 20-September 07

SQL

Post icon  Posted 20 September 2007 - 11:31 PM

hi,
how to get names start from similar alphabet from database
Is This A Good Question/Topic? 0
  • +

Replies To: SQL

#2 UltraFlynn  Icon User is offline

  • D.I.C Head
  • member icon

Reputation: 2
  • View blog
  • Posts: 136
  • Joined: 03-August 07

Re: SQL

Posted 21 September 2007 - 12:33 AM

Is that a question?

To get name starting with the same letter in most databases you use:

select * from customer where name like 'r%'

Was This Post Helpful? 0
  • +
  • -

#3 Rg2005  Icon User is offline

  • New D.I.C Head

Reputation: 1
  • View blog
  • Posts: 9
  • Joined: 20-September 07

Re: SQL

Posted 21 September 2007 - 02:53 AM

View PostFlynn, on 21 Sep, 2007 - 12:33 AM, said:

Is that a question?

To get name starting with the same letter in most databases you use:

select * from customer where name like 'r%'



View PostRg2005, on 21 Sep, 2007 - 02:51 AM, said:

View PostFlynn, on 21 Sep, 2007 - 12:33 AM, said:

Is that a question?

To get name starting with the same letter in most databases you use:

select * from customer where name like 'r%'



Thanks.
Was This Post Helpful? 0
  • +
  • -

#4 sapandavim  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 08-October 07

Re: SQL

Posted 08 October 2007 - 08:50 AM

View PostRg2005, on 20 Sep, 2007 - 11:31 PM, said:

hi,
how to get names start from similar alphabet from database


we can get the name from the database that r similar to the first of another letter
select * from tablename where attribute_value like '%s';
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1