select visitno,pressure ,left(pressure,locate("/",pressure)-1) as pup ,mid(pressure,locate("/",pressure)+1,length(pressure)-locate("/",pressure)) as plo
from visit
where pressure is not null AND locate("/",pressure) > 1 AND length(pressure)>locate("/",pressure)
