How to select a single data inside of a column?

i dont know if my question is correct sorry for wrong English grammar but my sample question is this, i have a column named address inside of this column is like this qqq/aaa/bbb and i only want to select bbb inside of the column address and select it along with other columns.