/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

7 votes263 views3 answers
Can't connect to local mysql server through socket '/tmp/mysql.sock' (2)
SQL
1 vote268 views1 answer
Postgresql create table with timestamp
SQL
13 votes277 views1 answer
Views in sql
SQL
0 vote260 views1 answer
Oracle sql winter time change
SQL
0 vote261 views1 answer
Narural join
SQL
2 votes256 views4 answers
How to find 2nd highest salary in mysql
SQL
3 votes278 views1 answer
Oracle sleep
SQL
0 vote276 views1 answer
Running percentage of total postgres
SQL
4 votes270 views1 answer
Id increment ms sql server
SQL
0 vote271 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL

Share