Mysql Select search

Hi All,

I am trying create a SELECT query on a Mysql database to find records that match the search text field.
ie txtSearch.Text ="B" and records in database "Brown" , "Britten" etc

Database "Persons", Table "table" and column "name"

Trying to get this to work.

cursor = Sql.ExecQuery2("SELECT * FROM table WHERE name LIKE ?",Array As String(txtSearch.text))

Can someone tell me if this looks correct?

Thanks

from B4X Community - Android, iOS, desktop, server and IoT programming tools http://ift.tt/2cjiMT3
via IFTTT