PluginStore API - get row by attribute

Sviluppatore
2

It sounds like your query isn’t using a good enough WHERE

The table’s schema is

plugin_store_rows
id    serial    primary key 
plugin_name    varchar(255) 
key    varchar(255) 
type_name    varchar(255) 
value    text    null

So the optimal query would be something like

SELECT the_fields, I_want, returned
FROM plugin_store_rows
WHERE appropriate_field LIKE 'some_text_string'
1 Mi Piace