Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Location
    Manila, Philippines
    Posts
    132

    Talking Unanswered: wildcards in query

    hi,
    can i use wildcards in where clause and in innerjoin clause?
    e.g.
    where table1.column1 = '*.12345'
    inner join table2 on table1.*.id* = table2.id

    thanks
    Take Nothing But Pictures;
    Leave Nothing But Footprints;
    Kill Nothing But Time;

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yes, you can use wildcards, but only in literals

    no, it's not an asterisk, it's the percent sign, and it's used only with LIKE

    you cannot use wildcards with column names
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

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