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