you missed 'composer' and 'releasedate' not ';'
here is my code which work with multiple search
query.prepare( "SELECT name, surname FROM people WHERE ( ( name LIKE :name ) OR ( surname LIKE :surname ) )" );
query.bindValue( ":name", "%" + first_name + "%" );
query.bindValue( ":surname", "%" + surname + "%" );
query.exec();
QString first_name = "arc";
QString surname = "LA";
query.prepare( "SELECT name, surname FROM people WHERE ( ( name LIKE :name ) OR ( surname LIKE :surname ) )" );
query.bindValue( ":name", "%" + first_name + "%" );
query.bindValue( ":surname", "%" + surname + "%" );
query.exec();
To copy to clipboard, switch view to plain text mode
Bookmarks