Wildcard in DELETE IN

softwareuser · #1 (**permalink**) 08-01-11, 12:08

Is there a way to use wildcards in a DELETE IN statement? Here's what I had in mind, but it doesn't work.

DELETE FROM table1 WHERE id IN (
SELECT CONCAT(id,'/page/%') FROM table2
)

r937 · #2 (**permalink**) 08-01-11, 12:27

your table1 ids are strings? that's weird, most people use integers

softwareuser · #3 (**permalink**) 08-01-11, 12:32

It's just an example. I didn't see the need to copy my exact field names coz they're very long. The fact that I used a generic table name, table1, in the example should indicate that.