1st letter querry
This is a discussion on 1st letter querry within the MySQL forums, part of the Database Server Software category; --> Hi There is posible tu get just 1st letter From database row using just one querry And Letter shouldn't ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 11:05 AM
| ||||
| ||||
 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      |
|
02-28-2008, 11:05 AM
| |||
| |||
| Re: 1st letter querry On 22 Jun, 11:31, Sebastian <haja.sebast...@gmail.com> wrote: > 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 SELECT LEFT(`companyName`,1) FROM `Company` |
|
02-28-2008, 11:05 AM
| |||
| |||
| Re: 1st letter querry On Jun 22, 3:31 pm, Sebastian <haja.sebast...@gmail.com> wrote: > 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 SELECT DISTINCT LEFT(`companyName`,1) FROM `Company` |
|
02-28-2008, 11:05 AM
| |||
| |||
| Re: 1st letter querry On Jun 22, 3:31 pm, Sebastian <haja.sebast...@gmail.com> wrote: > 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 SELECT distinct LEFT(`companyName`,1) FROM `Company` |
|
02-28-2008, 11:05 AM
| ||||
| ||||
| Re: 1st letter querry sandee.goyal04@gmail.com wrote in news:1182520180.626097.230430 @o11g2000prd.googlegroups.com: > On Jun 22, 3:31 pm, Sebastian <haja.sebast...@gmail.com> wrote: >> 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 > > SELECT distinct > LEFT(`companyName`,1) > FROM `Company` ORDER BY companyName  |
Linear Mode
