/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 vote160 views1 answer
Mysqldump don't drop table
SQL
0 vote151 views1 answer
Mysql count with two joins
SQL
20 votes169 views4 answers
Sql count if
SQL
-1 vote153 views8 answers
Create Trigger in phpMyAdmin
SQL
0 vote148 views1 answer
Mysql change default collation
SQL
0 vote156 views1 answer
Add timestamp column to existing table t-sql
SQL
0 vote145 views1 answer
Use where instead of join
SQL
0 vote187 views3 answers
Constraint sql
SQL
2 votes156 views1 answer
How to get weekday from old date in sql
SQL
1 vote147 views3 answers
Execute sp in sql server
SQL

Share