Results 1 to 2 of 2

Thread: Select domain

  1. #1
    Join Date
    Jul 2003
    Posts
    15

    Unanswered: Select domain

    I need to select urls for Facebook and MySpace domains.
    In my select query I have the following statement bellow:
    url LIKE lower('%myspace.%')
    OR Click.url LIKE lower('%facebook.%'))
    However, I am not sure whether this select will return only facebook and myspace domains. Does anybody know better solution?

    Thanks,

    Katya

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink Lower it

    Maybe this would be better:
    Code:
         LOWER(url)     LIKE '%myspace.%'
    OR LOWER(Click.url) LIKE '%facebook.%')
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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