SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: substring

  1. #1
    SitePoint Addict
    Join Date
    Jun 2008
    Posts
    203
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    substring

    There is field called "text" and it is concatenated with the delimiter '##'.

    How to select all the values before the delimiter '##'

    And

    How to select all the values after the delimiter '##'

  2. #2
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,513
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    which database system? MS Access? Informix? DB2?
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Addict
    Join Date
    Jun 2008
    Posts
    203
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I am using MySql database

  4. #4
    SQL Consultant silver trophybronze trophy
    SitePoint Award Recipient r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    38,513
    Mentioned
    35 Post(s)
    Tagged
    1 Thread(s)
    does the data have any single # characters in it? or just the double?
    r937.com | rudy.ca | Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •