wildcards in query

homer.favenir · #1 (**permalink**) 02-26-08, 00:00

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

r937 · #2 (**permalink**) 02-26-08, 02:35

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

Internet Services

Web Development

Digital Marketing

Consumer Tech