/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 vote98 views1 answer
List MySQL Table and Index Size
SQL
12 votes173 views2 answers
Find duplicates mysql column
SQL
0 vote101 views1 answer
Database xml sql
SQL
7 votes106 views2 answers
Mysql db size
SQL
0 vote102 views1 answer
Renommer schema sql
SQL
3 votes98 views1 answer
DB: in eloquent using sql
SQL
1 vote106 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote96 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote116 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote108 views1 answer
MySQL get all previous date record
SQL

Share