/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 vote260 views1 answer
SQL Server modify_timestamp trigger
SQL
1 vote289 views1 answer
Sqlite update from another table
SQL
0 vote265 views1 answer
Replace multiple string in query sql
SQL
0 vote228 views1 answer
Calculate discount from original price sql
SQL
0 vote264 views1 answer
Fill up postgres db
SQL
0 vote288 views1 answer
ORA-13717
SQL
2 votes302 views1 answer
How to select from mssql
SQL
0 vote270 views1 answer
Data structures in sql
SQL
19 votes274 views6 answers
What is mySQL
SQL
2 votes276 views2 answers
Sql first character
SQL

Share