* Peter Lovatt <[EMAIL PROTECTED]> [040413 16:27]:
> Hi
>
> select left(field, 1) from table where field = "something"
>
> http://dev.mysql.com/doc/mysql/en/String_functions.html
* Kevin Carlson <[EMAIL PROTECTED]> [040413 16:27]:
> try this:
>
> select LEFT(names, 1) from table
Thanks folks.
I love it!
tim
<..> > another way of asking my questions would be,
> > Is it possible to truncate columns in selection
> > set to a specific length (in the case: 1)
> >
> > Pointers to relevant documents are welcome.
--
Tim Johnson <[EMAIL PROTECTED]>
http://www.alaska-internet-solutions.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
