/SQL/Check if word is in column sql

Check if word is in column sql

Check if word is in column sql

SELECT * FROM STUDENTS WHERE STUDENTID like '%Searchstring%'

1

Source: stackoverflow.com

Sql query to check if column contains alphabets

SELECT * 
FROM table_name
WHERE CAST(PRIME_KEY AS STRING) RLIKE '([0-9]+[a-z]+)'

0

Similar codes

0 vote435 views1 answer
Restart serial number for postgres
SQL
2 votes327 views1 answer
Apex execute batch job
SQL
2 votes327 views1 answer
Alter table add multiple columns postgresql
SQL
1 vote317 views1 answer
Autocommit mysql
SQL
2 votes334 views2 answers
Change varchar length mysql
SQL
0 vote330 views1 answer
Postgresql import a database of gzip
SQL
1 vote346 views3 answers
Java.sql.sqlexception: access denied for user
SQL
4 votes338 views4 answers
Pl sql output
SQL
0 vote355 views1 answer
Kill mysqld_safe process mariadb
SQL
1 vote349 views1 answer
Update mysql centos
SQL

Share