How to search in Database

I want to find completed orders of some particular restaurant from database. What should i do to find it?

Bramgoogly in the admin dashboard goto Orders and search with the restaurant name and you will get all orders of the restaurant.

You can set the limit from drop-down to 500 and download the CSV data also.

===

If you want to do it with PhpMyAdmin, then you can so a search on the database table "orders" nd filter with the restaurant_id

Anyone there!! Plz help

I need the database query.. like select 'orders' ..

SELECT * FROM orders WHERE restaurant_id = '1' AND orderstatus_id = '5'

Thankyou, that's what i needed.