explode string in mysql

MySQL query - pieces of string with a specific substring in filed data. you can use an alias in "where"...