mardi 8 mars 2016

Select records with substr

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