/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 vote316 views6 answers
Unique key in sql
SQL
1 vote317 views1 answer
How to print longest name in sql
SQL
0 vote353 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
49 votes425 views6 answers
Install mysql ubuntu
SQL
7 votes339 views1 answer
Alter sequence set current value oracle
SQL
0 vote334 views1 answer
Avoid duplicate in one to many relationship join in sql
SQL
0 vote368 views1 answer
Delete from table where length sql
SQL
2 votes356 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote335 views1 answer
Executescalar in sql server
SQL
0 vote338 views1 answer
Create database like
SQL

Share