Sql

Search

how to find special characters in sql

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

Comment

PREVIOUS	NEXT

Code Example
Sql :: influxdb list all tags for a measurement
Sql :: oracle nvl
Sql :: insert into values select
Sql :: createdb with postgresql on ubuntu
Sql :: combine 2 columns search query mysql
Sql :: check if value is null mysql
Sql :: Add image in MySQL database
Sql :: sql query to find percentage of null values in a table
Sql :: sql delete column
Sql :: invalid column name sql
Sql :: alter or change postgresql sequence counter
Sql :: sql where time stamp is in between
Sql :: How to insert data in mysql ?
Sql :: sql select if two columns are equal
Sql :: oracle nvl2
Sql :: sql sequence
Sql :: image for MSSQL Windows Docker
Sql :: query to find second highest salary
Sql :: how to declare a variable in sql
Sql :: postgres sum when
Sql :: default value false mysql
Sql :: Add colum sqlite table
Sql :: update multiple columns in sql
Sql :: mysql disable triggers
Sql :: oracle error compilation line
Sql :: SQL COUNT() with GROUP BY
Sql :: oracle privileges users
Sql :: insert in sql
Sql :: psql check tables command
Sql :: sqrt(i)

Search

SQL

how to find special characters in sql

ADD CONTENT