Mysql database Query check digit

Question

I have table grocery_items with column plu_items which has 12 digit upc code, for ex 123456789123.

How to to remove the last check digit i:e "3" in above ex. in a sql query?

Possible duplicate of [Strip last two characters of a column in MySQL](https://stackoverflow.com/questions/6080662/strip-last-two-characters-of-a-column-in-mysql) — Ali Sheikhpour, Oct 26 '17 at 11:43

Gordon Linoff · Answer 1 · 2017-10-26T12:30:02.530

1

Just use left():

select left(plu_items, length(plu_items) - 1)
from grocery_items;

You should review MySQL string functions. They are well-documented.

If you actually want to remove the last digit from the data, use update:

update grocery_items
    set plu_items = left(plu_items, length(plu_items) - 1);

Be careful, because this affects all the data.

edited Oct 26 '17 at 12:30

answered Oct 26 '17 at 11:41

Gordon Linoff

Here (plu_times)? – user1801718 Oct 26 '17 at 11:51
Thanks its show me the result perfect.But how i can remove that last digit ? – user1801718 Oct 26 '17 at 12:28

score 0 · Answer 2 · answered Oct 26 '17 at 11:45

0

You can just divide by 10

select cast(plu_items / 10 as unsigned) as plu_items
from grocery_items

answered Oct 26 '17 at 11:45

juergen d

Thanks,its show me the result.But how i can remove that last digit ? – user1801718 Oct 26 '17 at 12:16

2 Answers2