/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

5 votes132 views2 answers
Sql number columns
SQL
0 vote146 views1 answer
Oracle date winter time
SQL
0 vote134 views1 answer
Fill up postgres db
SQL
0 vote137 views1 answer
Sql server datetime to string
SQL
3 votes132 views2 answers
Current year sql
SQL
19 votes147 views3 answers
How to change column type psql
SQL
6 votes140 views2 answers
Mysql check auto increment value
SQL
5 votes173 views1 answer
Ora-00054 resource busy and acquire with nowait
SQL
2 votes137 views2 answers
Useradd postgres
SQL
0 vote137 views1 answer
Docker export psql sql
SQL

Share