Support » Plugin: ABASE » Proper Syntax To Search Table and Display Results

  • The plugin is properly installed and I can return a basic query for an entire table……..I’m stuck on how to query the table and only return specific results.

    For example, I have businesses listed in the table, with a “city” field……I would like to query the table and return only entries that match a specific city, like “Boston” or “Dallas”.

    Any input would be appreciated……nice app!

    http://wordpress.org/plugins/abase/

Viewing 7 replies - 1 through 7 (of 7 total)
  • You will need to use the Where clause in your select statement. This will enable you to specify the city or cities of interest.

    Thanks….would you be able to show me an example with the where clause included?

    Here’s an example, I know this won’t filter, I tried…

    [abase SELECT * FROM table=”wp_raw_data” WHERE city=’Boston’]

    Ok, I can query the table listed below and only show the 2 columns listed….any help on adding the Where clause to pull only listings for a specific city, like “Boston” or “Miami” would be appreciated.

    [abase table=”wp_raw_data” columns=”Name,City”]

    I am not sure, but try City rather than city

    Can someone please help. I am also trying to use the where statement. What would be the format of this?

    Having the same issue! Has anyone found a solution to this?

    esmi

    (@esmi)

    Forum Moderator

    If you require assistance then, as per the Forum Welcome, please post your own topic instead of tagging onto someone else’s topic.

    I am now closing this 5 month old topic as it references an older version of WordPress.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Proper Syntax To Search Table and Display Results’ is closed to new replies.