dimanche 13 décembre 2015

SQLite matching column name , ignoring commas

I've got a database with several columns and a column name and I'm doing the following sqlite statement through OrmLite:

SELECT `name`,`id`,`ita_name`,`setCode`
FROM `MyTable`
WHERE (`name` LIKE ?)
ORDER BY `name` LIMIT 30

everything works fine but if the value of the name column is "Michael*,* Basketball player" and I submit "Michael Basketball player" the query return no results. I've already tried to use %myQueryText% but with no success. What can i do to return values from my column ignoring "," ?

Aucun commentaire:

Enregistrer un commentaire