/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 vote207 views1 answer
TITLE: SQL Server principal "dbo" does not exist
SQL
1 vote236 views1 answer
Group_concat order by
SQL
0 vote230 views1 answer
Implicit inner join table alias
SQL
0 vote221 views1 answer
Mysql read row
SQL
0 vote230 views1 answer
Postgresql in vs any performance
SQL
1 vote226 views2 answers
Laravel get sql query eloquent with parameters
SQL
2 votes214 views1 answer
Oracle index size
SQL
1 vote210 views1 answer
Temp table vs variable table in sql server
SQL
0 vote246 views1 answer
Psql initialization
SQL
4 votes218 views3 answers
How to describe a table in sqlite3
SQL

Share