mercredi 8 avril 2015

SQLite - Compare numeric value contained in string

I'm looking for something since months, and cannot figure it out So lets say I have the following table



id (numeric)
name (string)
description (string)


And the following data :



id|name |description
1 |Master Op|This is level 20, It can hurt 17 times
2 |Little Op|This is level 7,It can hurt 1 times
3 |Op Op |This is level 100,It can hurt 230 times


I'd like to get a way to search, based on hurts time, and return the name like if hurt > 200 it should return



Op Op


I dont know if this is possible, thanks


Aucun commentaire:

Enregistrer un commentaire