1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

In a property booking section want a query to check that
property is booked from StartDate to EndDate.Booking Table
field are given

id
proerty_id
start_date
checkout_date
no_of_visitor
booking date
status

Waiting yours answer..
Thanks In Advance...

Question Posted / sudhanshu_kmr

Answer Posted / sudhanshu_kmr

select * from property_table where
to_days(bookingdate)> to_days(startdate) and to_days(bookingdate)< to_days(enddate) ;

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is mysqli_free_result?

506

How can you change the name of any existing table by using the sql statement?

510

What sql does mysql use?

487

What are the different tables present in MySQL?

559

What is striped backup

1826




How to drop an existing index in mysql?

551

What is the difference between database and table?

568

What is the difference between a heap table and temporary table?

503

Write command to import an mysql file?

511

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

515

What is not null in mysql?

513

Is mysql still popular?

490

Is mysql free for commercial use?

470

Can I install mysql on mac?

522

What is mysql and mysqli?

475