How to use WHERE statement

  • dipeshthetime

    (@dipeshthetime)


    9 years, 11 months ago

    Hi Richard,

    One more question.

    See this shortcode below.

    [abase form=”1,search,http://housenkid.com/search-results/” table=”HNKID” columns=”ItemName=%ItemName%$Search HousenKid” elements=”ItemName” where=”Status=1″]

    I am trying to get only the data that has the Status value of 1. Status is a column in my database. Basically I am trying to filter the data where Status is 1. 1 means we have it and -1 means we don’t. What am I doing wrong? Thanks.

    https://wordpress.org/plugins/abase/

  • The topic ‘How to use WHERE statement’ is closed to new replies.