/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

1 vote118 views3 answers
Drop unique key constraint in sql server
SQL
-1 vote65 views2 answers
Datetime sql server week
SQL
0 vote110 views1 answer
Pl/sql loop example
SQL
0 vote127 views1 answer
Shows all databases created by user in ms sql
SQL
0 vote120 views1 answer
Select row with latest date mysql
SQL
0 vote128 views1 answer
T sql dynamic top n query
SQL
7 votes119 views6 answers
Group_concat in mysql
SQL
0 vote121 views1 answer
Postgresql auto increment not working
SQL
2 votes115 views1 answer
Set column to not null mysql
SQL
0 vote126 views1 answer
Allow null in psql
SQL

Share