/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 vote304 views2 answers
Mysql updating multiple column values from array variable
SQL
1 vote339 views1 answer
Print year of a date sql
SQL
0 vote352 views1 answer
Dataframe lambda elif
SQL
1 vote330 views1 answer
Wherein mysql
SQL
1 vote356 views2 answers
Intersect sql
SQL
0 vote317 views1 answer
Fast sql column count
SQL
0 vote317 views1 answer
Alasql delete column
SQL
0 vote311 views1 answer
Sql get guid
SQL
0 vote342 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL
5 votes321 views2 answers
Mysql import gzip db
SQL

Share