How to select only first few letters of a field

sidsel

How do I select only the first 10 letters of a field?

I tried "Select blabla(10) from table" but it doesn't work.

bad76

Hi,
a look to mysql manual give you two function, LEFT() and SUBSTRING().

see you

sidsel

How do I put this into my query?

I'm trying to select the first 10 letters from a column named 'header'.

Select bla1, bla2, bla3, LEFT('header', 10) FROM table

The above doesn't work.

LordShryku

Do it without the single quotes

bad76

Originally posted by sidsel
How do I put this into my query?

I'm trying to select the first 10 letters from a column named 'header'.

Select bla1, bla2, bla3, LEFT('header', 10) FROM table

The above doesn't work.

When you use a function, you have to give it an alias:

Select bla1, bla2, bla3, LEFT(header, 10) as myhead FROM table

Then you can access through $row["myhead"].

I hope this help you.