Special character query in SQL

Asked

Viewed 32 times

2

I need to make a query in a table of emails, and I need to return only emails that have special characters.

Can you help me with the script, I tried to use this code:

Select * from tabela Where Coluna LIKE '%[^A-Za-z0-9, ]%'

but without success.

sql select characters

  • Inform the DBMS, some syntheses change.

  • If your database is Mysql, SELECT * FROM tabela WHERE coluna REGEXP '[^A-Za-z0-9, ]'. It is worth remembering that, possibly, the query will bring all the emails that also possess the @.

No answers

Browser other questions tagged sql select characters

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