Multiple Conditions Query SqLite

You must Login before you can answer or comment on any questions.

Hi,

I am going to pull my hair!

I am trying to retrieve data from my database but with multiple conditions

SELECT * FROM my_table WHERE id_medecine = id and area = myAreaId
But it's not working, i also executed the query with my software "Sql Data Browser" it returns me nothing...

So i ask you could i do this.

Thanks ;)

1 Answer

Yes this is posible. You can add 2, 3, 6.. conditions. Make sure you have data in you table that satisfies this conditions, also double check your variable parameters and the final query string that you are passing.

Your Answer

Think you can help? Login to answer this question!