data.world
Contents
  • Concepts
    • Basic
      • Learn SQL Basics
      • The SELECT and FROM Clauses
      • The SELECT * EXCLUDE and SELECT * RENAME Clauses
      • LIMIT
      • WHERE and Comparison Operators
      • ORDER BY
      • AND, OR, and NOT
      • Arithmetic Operations
      • IS NULL and IS NOT NULL
      • LIKE and NOT LIKE
      • BETWEEN
      • OFFSET
    • Intermediate
      • Working With Joins, Aggregations, and Built-In Functions
      • Joins
      • CAST
      • Aggregations
      • GROUP BY and FILTER
      • HAVING
      • UNION, INTERSECT, and MINUS
      • POSITION
      • CASE
      • IN and NOT IN
      • Working With Strings
      • Working With Dates
      • Working With Arrays
    • Advanced
      • WITH
      • Inline Subqueries
      • Value blocks
      • Special Uses of Inline Subqueries
      • Advanced Aggregate Functions
      • Windowed Aggregations
      • ROLLUP and CUBE
      • PIVOT
      • UNPIVOT
      • TABLESAMPLE
      • Metadata Tables
      • Lexical Issues
    • data.world Specific
      • Multi-Tables
      • Federated Queries
      • Parameterized Queries
      • Special Columns
      • Query past instances of data
      • Text formatting for query outputs
  • Reference
    • Boolean Aggregations
    • Regression Aggregations
    • Standard Aggregations
    • Statistical Aggregations
    • Other Aggregations
    • PRAGMA Statements
    • All Functions
    • Color Functions
    • Array Functions
    • Date Functions
    • Formatting Functions
    • General Functions
    • Linked Data Functions
    • Hashing and Related Functions
    • Math Functions
    • Security Functions
    • String Functions
    • URL Extraction Functions
    • Aggregations
      • APPROX_MEDIAN
      • APPROX_DISTINCT
      • ARBITRARY
      • APPROX_PERCENTILE
      • ARRAY_AGG
      • AVG
      • BOOL_AND
      • BOOL_OR
      • CHECKSUM
      • COUNT
      • CORRELATION
      • COUNT_IF
      • COVAR_POP
      • COVAR_SAMP
      • CUME_DIST
      • DENSE_RANK
      • FIRST_VALUE
      • GROUP_CONCAT
      • LAG
      • KURTOSIS
      • GROUPING
      • LEAD
      • LAST_VALUE
      • MAX
      • MIN
      • MIN_BY
      • MAX_BY
      • NTH_VALUE
      • PERCENT_RANK
      • NTILE
      • RANK
      • REGR_AVGY
      • REGR_COUNT
      • REGR_AVGX
      • REGR_R2
      • REGR_INTERCEPT
      • REGR_SXX
      • REGR_SLOPE
      • REGR_SXY
      • REGR_SYY
      • ROW_NUMBER
      • STD_SAMP
      • SKEWNESS
      • STD_POP
      • STDEV
      • SUM
      • VAR_SAMP
      • VAR_POP
      • VARIANCE
    • Functions
      • ABS
      • ARRAY
      • ACOS
      • ARRAY_CONCAT
      • ARRAY_CONTAINS
      • ARRAY_LOWER
      • ARRAY_JOIN
      • ARRAY_APPEND
      • ARRAY_LENGTH
      • ARRAY_PREPEND
      • ARRAY_UPPER
      • ATAN
      • ASIN
      • AT_TIME_ZONE
      • ATAN2
      • ATTR_OF
      • BASE64_TO_HEX
      • BOLD
      • CHAR
      • CONCAT
      • CEILING
      • COLOR
      • COALESCE
      • COS
      • CURRENT_USER
      • COSH
      • CURRENT_USER_IN_GROUP
      • DATE_ADD
      • DATE_COMPARE
      • DATE_FORMAT
      • DATE_DIFF
      • DATE_PART
      • DAY
      • DATE_PARSE
      • DATE_SUB
      • DATE_TRUNC
      • DEGREES
      • ELEMENT_AT
      • ENDSWITH
      • EXP
      • EXP10
      • FLOOR
      • GENERATE_SERIES
      • GREATEST
      • IF
      • HEX_TO_BASE64
      • IRI_OF
      • IRI_TO_RESOURCE_HASH
      • ITALIC
      • HOURS
      • JARO_WINKLER_DISTANCE
      • LEAST
      • LABEL_OF
      • LEFT
      • LENGTH
      • LEVENSHTEIN_DISTANCE
      • LOG
      • LOG10
      • LOWER
      • LPAD
      • LTRIM
      • MD5
      • MID
      • MINUTES
      • MOD
      • NOW
      • MONTH
      • NOW_UTC
      • POSITION
      • PI
      • POW
      • RADIANS
      • RAND
      • RANDOM
      • REGEXP_EXTRACT
      • REGEX
      • REPLACE
      • REVERSE
      • RIGHT
      • RGB
      • ROUND
      • RTRIM
      • RPAD
      • SECONDS
      • SHA1
      • SHA256
      • SHA384
      • SHA512
      • SIGN
      • SIN
      • SINH
      • SOUNDEX
      • SOUNDEX_DISTANCE
      • SQRT
      • STARTSWITH
      • STATUS
      • STR_AFTER
      • STR_BEFORE
      • STR_CONTAINS
      • TAN
      • STRING_SPLIT
      • SUBSTRING
      • TANH
      • TRIM
      • TRUNC
      • UPPER
      • URL_EXTRACT_FRAGMENT
      • URL_EXTRACT_HOST
      • URL_EXTRACT_PARAMETER
      • URL_EXTRACT_PATH
      • URL_EXTRACT_PORT
      • URL_EXTRACT_PROTOCOL
      • URL_EXTRACT_QUERY
      • WITH_BACKGROUND_COLOR
      • WITH_COLOR
      • WITH_LINK
      • WITH_STATUS
      • YEAR
Reference/

URL Extraction Functions

A list of url extraction functions

  • URL_EXTRACT_FRAGMENT
  • URL_EXTRACT_HOST
  • URL_EXTRACT_PARAMETER
  • URL_EXTRACT_PATH
  • URL_EXTRACT_PORT
  • URL_EXTRACT_PROTOCOL
  • URL_EXTRACT_QUERY