Remove white space in select (SQL)

Question

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

Answer 1

Use the TRIM function:

SELECT id FROM BAIRRO WHERE TRIM(NOME) LIKE 'Areao' ;

https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_trim