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