/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 vote148 views1 answer
Create duplicate table in postgresql
SQL
0 vote194 views2 answers
Sqlalchemy core in clause
SQL
0 vote203 views2 answers
How to install psql in ubuntu
SQL
0 vote190 views1 answer
Sql query to get column names and data types in sql server
SQL
1 vote186 views1 answer
Mysql not supported auth mode
SQL
1 vote174 views1 answer
How to get mysql db size
SQL
0 vote184 views1 answer
What is between operator
SQL
1 vote205 views1 answer
Opensuse restart MySQL
SQL
2 votes211 views2 answers
Calculate percentage in sql
SQL
0 vote189 views1 answer
Set open file limit mac catalina mysql
SQL

Share