How to use between operator in mysql

Posted on 2012-09-10
Last Modified: 2012-09-11
My datas has been stored like below:


I am using this query:

select * from jobcard where Deleted!='1'  and JDated  between '2012-07-13' and '2012-09-17' order by JNo desc

But i didn't get that values.

When i execute this query the output should be displayed like below:

How to get that values using mysql query.
Question by:jnj_web_solutions
    LVL 5

    Assisted Solution

    I had a similar problem and this helped me. Let me know.
    LVL 13

    Accepted Solution

    Is your data actually stored as pipe separated dates or as separate rows? If it is separate rows, the output should be correct.
    If not, you would need to write something to parse pipe separated dates and convert it into rows and then apply between on the same.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now