/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

5 votes168 views2 answers
Mysqldump password
SQL
1 vote191 views1 answer
Oracle split string
SQL
1 vote180 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote171 views1 answer
Sql case sttement with set
SQL
1 vote222 views1 answer
Add time to date sql
SQL
0 vote182 views1 answer
Enable sql server full text indexing
SQL
17 votes224 views6 answers
MySQL ORDER BY
SQL
0 vote237 views1 answer
MySQL - How to find word with the most similar beginning
SQL
9 votes170 views3 answers
Oracle undo usage by session
SQL
0 vote200 views2 answers
Oracle ora-00054 how to unlock
SQL

Share