Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT REGEXP_SUBSTR(name, '[^|]+', 1, 1) FIELD_1,
- REGEXP_SUBSTR(name, '[^|]+', 1, 2) FIELD_2,
- REGEXP_SUBSTR(name, '[^|]+', 1, 3) FIELD_3,
- REGEXP_SUBSTR(name, '[^|]+', 1, 4) FIELD_4,
- REGEXP_SUBSTR(name, '[^|]+', 1, 5) FIELD_5,
- REGEXP_SUBSTR(name, '[^|]+', 1, 6) FIELD_6
- FROM oc_poi
- WHERE oc_poi_category_id = 101901
- AND oc_poi_status_id = 0
- AND REGEXP_SUBSTR(name, '[^|]+', 1, 6) IS NULL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement