QSqlTableModel and LIKE

[JeanC]

Hi it's me again

How can I filter a QSqlTableModel so that only rows show up that have a certain cell contain a substring, like the sql LIKE clause?
The setFilter() member filters only on the whole string.

I tried a query like:

QString str = QString("SELECT * FROM pix WHERE 'name' LIKE '%%1%'").arg(nameEdit->text());
QSqlQuery query(str);
model->select();

QString str = QString("SELECT * FROM pix WHERE 'name' LIKE '%%1%'").arg(nameEdit->text());
QSqlQuery query(str);
model->select();

To copy to clipboard, switch view to plain text mode 

But this seems not the way to go.

Thanks.

[jacek]

Use setFilter( QString("name LIKE '%%1%'").arg( str ) ), but make sure that "str" doesn't contain any malicious content.

[JeanC]

Thanks jacek, works right out of the box