In my table I have a column production with strings like 101014, 101015. I want to select all the records which end with 15. I asked with:
SELECT * FROM boxes where substr('production',5,2) = 15
or
SELECT * FROM boxes where substr('production',5) = 15
and nothing is returned..
Aucun commentaire:
Enregistrer un commentaire