Breaking News: Grepper is joining You.com. Read the official announcement!

how to find special characters in sql

Famous Flamingo answered on March 27, 2022 Popularity 9/10 Helpfulness 4/10

answer how to find special characters in sql

related special characters sql

how to find special characters in sql

Comment

/* Select Special Charcters only*/
select col1
	from table_name
    	where col1 like '%[!@#$%^&*]%'; 
        
Note : You can add any special character in WHERE clause

Popularity 9/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: find special-characters sql

Link to this answer
Share Copy Link

Contributed on Mar 27 2022

Famous Flamingo

0 Answers Avg Quality 2/10

Closely Related Answers

special characters sql

Comment

# "\" Allows special characters to be displayed / understood in SQL
\0 -- An ASCII NULL (0x00) character.
\' -- A single quote ( ' ) character.
\" -- A double quote ( " ) character.
\b -- A backspace character.
\n -- A newline (linefeed) character.
\r -- A carriage return character.
\t -- A tab character.
\Z -- ASCII 26 (Control-Z).

Popularity 8/10 Helpfulness 5/10 Language sql

Source: Grepper

Tags: special-characters special-character

Link to this answer
Share Copy Link