Substring() for Fields in MYSQL

Question

I don't understand why this didn't work out:

select id,name,concat(substring(description,0,30),'...') as desc_shortened, created_date,added_by from products

Even though there is data inside of the description field. I didn't see any field example on mySQL documentation tho. They used pure strings instead of column names.

concat(susbtring(description,0,30)) only returns ... and that's all.

a'r · Accepted Answer · 2011-07-21 16:58:31Z

8

Use substring(description,1,30) instead.

answered Jul 21, 2011 at 16:58

a'r

37.2k7 gold badges68 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tarik Over a year ago

I didn't know it starts with 1. I was hoping it would start with 0 . It is always like this?

Martin Over a year ago

depends on the language, and even on type. Strings in VB start with 0, Collections with 1 (with a dummy 0 inserted on creation)

nideyangzi1989 · Accepted Answer · 2015-02-03 03:11:31Z

0

Oracle treat 0 as 1 in this function, but mysql treat 0 as empty.So you should use substring(description,1,30).

answered Feb 3, 2015 at 3:11

nideyangzi1989

611 silver badge8 bronze badges

Collectives™ on Stack Overflow

Substring() for Fields in MYSQL

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related