String related operation in mysql

Question

I have written mysql code like

substr(a_code,1,ifnull(if((locate("-",a_code)>0),locate("-",a_code)-1,length(a_code)),0))

What it does is i have code like abcd-1 or abcd or abcd-2. I want to take out code part before -. It can be abcd or abcd-1 or abcd-n. So code is working fine. Can i make it in a better way.

Bill Karwin · Accepted Answer · 2014-04-30 07:03:54Z

2

You could write it this way:

substring_index(a_code,'-',1)

See http://dev.mysql.com/doc/refman/5.6/en/string-functions.html#function_substring-index

answered Apr 30, 2014 at 7:03

Bill Karwin

567k87 gold badges709 silver badges869 bronze badges

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

Collectives™ on Stack Overflow

String related operation in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related