hello
need help to get part of description column
table:orders
orderid and description
data is
(1,hdmi cable 1cd)
(2,hdmi cable 1dc)
(3,logitech mouse 1ab)
i need to query the description but it should show only from 1
1,1cd
2,1dc
3,1ab
how do i get that
thanks for your help