Professional Web Applications Themes

1st letter querry - MySQL

Hi There is posible tu get just 1st letter From database row using just one querry And Letter shouldn't be repleaced For example Table name: Company column name: companyName Values Albha Apple Beta Delta Dinosour Gama In result of querry i need have: A B D G Best Regards Sebastian Haja...

  1. #1

    Default 1st letter querry

    Hi

    There is posible tu get just 1st letter From database row using just
    one querry And Letter shouldn't be repleaced

    For example

    Table name: Company

    column name: companyName

    Values

    Albha
    Apple
    Beta
    Delta
    Dinosour
    Gama

    In result of querry i need have:

    A
    B
    D
    G

    Best Regards
    Sebastian Haja

    Sebastian Guest

  2. #2

    Default Re: 1st letter querry

    On 22 Jun, 11:31, Sebastian <com> wrote: 

    SELECT
    LEFT(`companyName`,1)
    FROM `Company`

    Captain Guest

  3. #3

    Default Re: 1st letter querry

    On Jun 22, 3:31 pm, Sebastian <com> wrote: 

    SELECT DISTINCT LEFT(`companyName`,1)
    FROM `Company`

    sandee.goyal04@gmail.com Guest

  4. #4

    Default Re: 1st letter querry

    On Jun 22, 3:31 pm, Sebastian <com> wrote: 

    SELECT distinct
    LEFT(`companyName`,1)
    FROM `Company`

    sandee.goyal04@gmail.com Guest

  5. #5

    Default Re: 1st letter querry

    com wrote in news:1182520180.626097.230430
    o11g2000prd.googlegroups.com:
     
    >
    > SELECT distinct
    > LEFT(`companyName`,1)
    > FROM `Company`[/ref]
    ORDER BY companyName

    ;)
    Good Guest

Similar Threads

  1. Changing from half letter to letter doent size
    By Jane_Evans@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 8
    Last Post: August 22nd, 05:56 PM
  2. Missing letter, letter replaced
    By joline_tan@adobeforums.com in forum Adobe Indesign Macintosh
    Replies: 0
    Last Post: July 23rd, 01:36 AM
  3. Capital letter to small letter in Flash MX
    By Rokkuman in forum Macromedia Flash Actionscript
    Replies: 1
    Last Post: February 17th, 05:04 PM
  4. letter by letter text display
    By Souske webforumsuser@macromedia.com in forum Macromedia Flash Sitedesign
    Replies: 1
    Last Post: October 29th, 05:09 AM
  5. Querry by date
    By Douglas J. Steele in forum Microsoft Access
    Replies: 2
    Last Post: July 5th, 01:30 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