/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 vote144 views1 answer
Oserror mysql_config not found virtualenv
SQL
0 vote157 views1 answer
Permission denied postgres \copy csv command line
SQL
0 vote124 views1 answer
SQL > Manipulação de Tabelas > Constraint
SQL
15 votes133 views5 answers
If null mysql
SQL
0 vote147 views1 answer
Shell script to log mysql cpu usage
SQL
5 votes148 views2 answers
Oracle show procedures
SQL
0 vote189 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
2 votes142 views2 answers
Sqlite_busy: database is locked
SQL
2 votes141 views2 answers
How to rename column name in sql server using query
SQL
25 votes157 views1 answer
How to update an attribute in MySQL
SQL

Share