DB integration: get rows where column contains "mysearchstring" and load results into variable for maniupulation

[webalchemist]

I have seen some tasker plugins for two different databases, but it seems they only offer insert or update one row, not any options for get row results based on search.

Any ideas here on how to get results?

I think I might have to create my own API on my website and have my website return the results to my phone but i'm really preferring everything to work in Offline mode instead of relying on an internet connection.

 

[tanutanu]

I have seen some tasker plugins for two different databases, but it seems they only offer insert or update one row, not any options for get row results based on search.

Any ideas here on how to get results?

I think I might have to create my own API on my website and have my website return the results to my phone but i'm really preferring everything to work in Offline mode instead of relying on an internet connection.

I'm not sure the plugin but single row could be returned if you could join 2 result as a row with sub query or so.
However, you got it into a variable in the MD world. I'm not positive to use RDBMS via MD. I recommend you to consider simple key value structures.