/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

2 votes178 views1 answer
Postgresql update sequence next value
SQL
1 vote158 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
0 vote188 views1 answer
Adding primery key constraint to a column
SQL
16 votes189 views4 answers
Mysql import from sql file
SQL
0 vote207 views1 answer
Replace sqlalchemy
SQL
0 vote233 views3 answers
Call to undefined function mysql_connect()
SQL
0 vote201 views2 answers
How to add CHECK constraint to a column in postgres
SQL
10 votes181 views4 answers
Primary key in sql
SQL
0 vote233 views2 answers
How to install psql in ubuntu
SQL
0 vote204 views1 answer
How to check oracle index table
SQL

Share