/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 vote288 views1 answer
ORA-00942
SQL
0 vote191 views1 answer
Minecraft duping allowed servers
SQL
1 vote318 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote235 views1 answer
Sql alter column name sql server
SQL
0 vote217 views1 answer
Sql order by except one row
SQL
0 vote261 views1 answer
Download mysql database to excel in android studio
SQL
0 vote191 views1 answer
Update if else mysql
SQL
0 vote229 views1 answer
How to retrive the today date sql
SQL
4 votes260 views3 answers
Postgres drop all tables
SQL
0 vote267 views1 answer
Mariadb disable foreign key checks
SQL

Share