|
|
Welcome to the Computer Webmaster Gaming Console Graphics Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
| |||||||
| Database Database problems or need to ask a question? maybe something to do with sql injections or a database software question. Database topics cover MySQL, PostgreSQL, Oracle, SQL Server or anything else related to databases. |
 |
| | LinkBack | Thread Tools | Display Modes |
07-02-2007, 10:58 AM
| #1 | ||
 |
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 | ||
     |
| Advertisements |
|
07-02-2007, 10:58 AM
| #2 | ||
| |
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` | ||
| |
|
07-02-2007, 10:58 AM
| #3 | ||
| |
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` | ||
| |
|
07-02-2007, 10:58 AM
| #4 | ||
| |
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` | ||
| |
|
07-02-2007, 10:58 AM
| #5 | ||
| |
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  | ||
| |
| Featured Websites | ||||
|
|
| Tags: 1st, letter, querry |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Mysql querry | Sebastian | Database | 4 | 07-01-2007 10:59 PM |
| Letter & bottle | Jane Withnolastname | The Games | 1 | 06-26-2007 1:09 AM |
| Red letter day NR | Stuart | Ebay Technical Questions | 0 | 05-31-2007 9:55 AM |
| Hi Money Makers, PLEASE READ The Letter | Ranxerox | Building An Internet Business | 0 | 05-29-2007 3:07 AM |
| Featured Websites | ||||
|
1st letter querry 
PacMan
Linear Mode
