&& command

[genzedu777]

Hi,

 

I believe my coding has written wrongly, I am trying to retrieve 3 records at the same time,

'Tbjjtwx'

'123456'

'414221'

 

SELECT  * FROM `tutor`WHERE `Tutor_ID` = 'Tbjjtwx' && '123456' && '414221'

//However no results were shown

 

But when I tried to search for only 1 ID, result was shown

SELECT  * FROM `tutor`WHERE `Tutor_ID` = 'Tbjjtwx'

 

Did I miss out anything? Thanks

 

 

[PFMaBiSmAd]

http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#function_in

[sangoku]

You may have noticed that that command is a logical command and that it is in notation of C++ language.... which almost all advanced lang. no longer support(me daydreaming). You could try and just write AND or OR or as the nice guy above me pointed out use the in case statement 

[genzedu777]

Hi guys,

 

I'm still confused, after reading the link I'm even more lost.

 

I have tried changing the && to AND, but it still doesn't work. Any idea? Thanks

 

SELECT * FROM `tutor` WHERE `Tutor_ID` = 'Tcolez5' AND 'Tbjjtwx' AND 'Tn4f9ym'

[trq]

Either....

 

SELECT * FROM `tutor` WHERE `Tutor_ID` = 'Tcolez5' AND `Tutor_ID` = 'Tbjjtwx' AND `Tutor_ID` = 'Tn4f9ym';

 

Or as PFMaBiSmAd pointed out.

 

SELECT * FROM `tutor` WHERE `Tutor_ID` IN('Tcolez5', 'Tbjjtwx', 'Tn4f9ym');

[genzedu777]

Thank you so much for the help!