query issue

[Alicia]

Hi,

 

May I know how can I get a proper query for this requirement :

 

SELECT * FROM Table WHERE columnA = 1 AND columnB =($A || $B || $C || $D )

$A,$B,$C and $D are values posted by user. If any of those variables have nothing inside/no value, it will not be included in the query.

 

E.g : If $(c == "") . the query will be

*SELECT * FROM Table WHERE columnA = 1 AND columnB =($A || $B || $D )

 

I tried conditional statement to accomplish this but failed. Some guru please advise on this. Thank you.

 

 

 

 

[kickstart]

Hi

 

Think what you are thinking of is

 

SELECT * FROM Table WHERE columnA = 1 AND columnB  IN ($A,$B,$C,$D )

 

or if text fields

 

SELECT * FROM Table WHERE columnA = 1 AND columnB  IN ('$A','$B','$C','$D' )

 

All the best

 

Keith

 

[Alicia]

An error displayed :

#1271 - Illegal mix of collations for operation ' IN '

 

SELECT * FROM cd WHERE  week  IN ('Te','Tev','Yed')

 

Please advise.

[kickstart]

Hi

 

Not sure. A quick google suggests the problem is down to a mismatch between the collation type of the data you are using and that which the column is declared with.

 

All the best

 

Keith