mysql in和like,MySQL IN与LIKE

How would I use a IN table with like? So that I could use % in them? By in I mean:

SELECT fields

FROM table

WHERE age = "50"

AND name IN ("tim", "bob", "nancy", "john");

I already tried:

SELECT fields

FROM table

WHERE age = "50"

AND name LIKE ("2010-09-17%", "2010-09-16%")

But it gave the error "Operand should contain 1 column(s)"

解决方案

You can use a number of LIKE expressions:

SELECT fields

FROM table

WHERE age = "50"

AND (

name LIKE "2010-09-17%"

OR name LIKE "2010-09-16%"

);

or you can use a regex:

SELECT fields

FROM table

WHERE age = "50"

AND name REGEXP "2010-09-17.*|2010-09-16.*";

or, cleverly

SELECT fields

FROM table

WHERE age = "50"

AND name REGEXP "2010-09-1(6|7).*";