How To build MySql Query to Get Call History From Database!

[groogruxking40]

Hi all expertz,
I am newly hire intern in web development field and my senior ask me to build mysql query to draw out call history from database.

They want me to build query to get call record of:
1- Today
2- Yesterday
3- Last Week
4- this week

Just give me sample code or give me hint. we are working on mobile billing app. Please help me it is very necessary for me because i am a fresh intern. Thanks

[mikewertheim]

It's impossible to answer this question without knowing what the database schema looks like.

I suggest starting out by learning some SQL. There is a really good free SQL tutorial online. Do a Google search for "SQL course" and click the "SQLCourse" result. Do both SQLCourse and SQLCourse2.

[JohnnyS]

Originally Posted by groogruxking40

Hi all expertz,
I am newly hire intern in web development field and my senior ask me to build mysql query to draw out call history from database.

They want me to build query to get call record of:
1- Today
2- Yesterday
3- Last Week
4- this week

Just give me sample code or give me hint. we are working on mobile billing app. Please help me it is very necessary for me because i am a fresh intern. Thanks

if you have a date field in your table, for example created_at or date_created. you can just create a query on that field..

today:

 SELECT * FROM calls_table WHERE DATE(date_create) = DATE(NOW())

you play with that query and try to combined some of the MySQL Date functions to achieve the result you want..