Sql returns empty row on combinning primary key with another value in where clause

Question

I am getting empty row on following sql SELECT * FROM flyers WHERE fId='6' AND 'userId'='400' MySQL returned an empty result set (i.e. zero rows). (Query took 0.0004 sec) But when i use SELECT * FROM flyers WHERE fId='6' Showing rows 0 - 0 (1 total, Query took 0.0005 sec). As i got my result and that is correct using only primary key. But i does not know why mysql returns empty row on using AND with primary key. Note:- fId is flyer table primary key. JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)

Answer 1

Try this: Use back ticks for the column name not single quotes If userid is int data type it means you have to remove single quotes userid=400 If fid is string it means fID='6' SELECT * FROM flyers WHEREfId=6 ANDuserId=400