/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

6 votes127 views1 answer
T-sql test if table exists
SQL
0 vote123 views1 answer
Where date major today mysql
SQL
0 vote120 views1 answer
How to check default value of column in sql server
SQL
0 vote192 views1 answer
Mysql update all record removing 2 hours from column
SQL
8 votes129 views2 answers
Alert table name mysql
SQL
0 vote127 views1 answer
Setval postgres example table id
SQL
5 votes130 views1 answer
Commentaire table oracle
SQL
1 vote124 views1 answer
How to check the mysql version mac
SQL
1 vote120 views6 answers
In sql
SQL
0 vote128 views1 answer
MySQL - Enabling the Event Scheduler
SQL

Share