I have to make a query to a database where I have a table of the data of people (name, address, colony, age, city, etc.) I want to obtain the addresses that necessarily have numbers, since I have some addresses where only the name of the street is but without number.
I've tried with:
... WHERE direccion LIKE '% [0-9]'
but I do not get results.