SQLite Query: match any integer

I have a query like this:

SELECT num1,num2,num3,num4 from num_cols WHERE num1=1 A开发者_StackOverflowND num2=2 AND num3=3 AND num4=4;

I would like to reuse this query in contexts in which I may not wish to match every number exactly, so if I could do something like this:

SELECT num1,num2,num3,num4 from num_cols WHERE num1=1 AND num2=2 AND num3=* AND num4=4;

where * would match any num3. Is there a character or function like * in sqlite3 which will match any value?

Is there one for integers? Is there one for strings?

Can you just leave num3 off the select list? Wouldn't that 'match' any integer? Or, if num3 could be null say

num3 is not null