Remove white space in select (SQL)

Asked

Viewed 423 times

-1

I wonder if you have any way to remove the blank space of the records returned in select.

for example I have the NEIGHBORHOOD table with the records Bela Vista 'Amazonas' ' Gravel'

but when I do

'''SELECT ID FROM NEIGHBORHOOD WHERE NAME LIKE 'AREAO' ;'''

it does not return the id precisely because of the space before the word areao

Then I wonder if there is any way to take this space without having to change all the records of the table

mysql sql regex

1 answer

2

Browser other questions tagged mysql sql regex

You are not signed in. Login or sign up in order to post.