* 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.
try this:
select LEFT(names, 1) from table
Tim Johnson wrote:
Hello:
Is it possible to use mysql to select only
the first letter of a string in a column?
IOWS "select names from table" ->
"select names from table"
another way of asking my questions would be,
Is it possible to truncate
Hello:
Is it possible to use mysql to select only
the first letter of a string in a column?
IOWS "select names from table" ->
"select names from table"
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)