/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

14 votes259 views3 answers
Sql trim from string
SQL
0 vote245 views1 answer
Fetch second word from a string in ms sql
SQL
27 votes257 views6 answers
Set password mysql
SQL
0 vote242 views1 answer
Query to get all primary keys and foreign key
SQL
1 vote286 views1 answer
Sql row having max
SQL
4 votes396 views6 answers
Laravel jwt
SQL
8 votes270 views1 answer
My sql version
SQL
27 votes263 views6 answers
Sql update record
SQL
0 vote263 views1 answer
Select top values sql
SQL
0 vote254 views1 answer
Last date for each user sql
SQL

Share