/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 vote234 views1 answer
Install squirrel sql ubuntu
SQL
1 vote175 views1 answer
Flask-sqlalchemy filter_by contains
SQL
25 votes229 views5 answers
Uninstall mysql ubuntu
SQL
5 votes227 views1 answer
Oracle nls parameters
SQL
4 votes224 views1 answer
Sql query to make a existing column auto increment
SQL
6 votes245 views2 answers
Mysql concatenate two columns into one
SQL
0 vote230 views1 answer
Oracle create job if not exists
SQL
0 vote246 views1 answer
Inserting values with beekeeper get error null value in column createdAt violates not-null constraint
SQL
1 vote246 views1 answer
Oracle check table lock
SQL
0 vote226 views1 answer
Loop through a table variable in TSQL without using a cursor
SQL

Share