0

I just altered a MySQL I have to only show the ones that have Broadcast_To_Home as (1) it can only be 1 or 0 so I am using it as a Boolean. My Query is shown below

SELECT * FROM blog WHERE Broadcast_To_Home IN(1) ORDERBY ID DESC LIMIT 3

Well using that as my Query I get the error shown in the title can anybody help me with this?

Thanks!

user1591117
  • 277
  • 2
  • 5
  • 13

1 Answers1

2

ORDERBY must be separated like that ORDER BY and

if you have just one value 1 why dont u use like that Broadcast_To_Home =1.?

try this

SELECT * FROM blog WHERE Broadcast_To_Home =1 ORDER BY ID DESC LIMIT 3
echo_Me
  • 36,552
  • 5
  • 55
  • 77