Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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) 
ADD CONTENT
Topic
Content
Source link
Name
9+5 =