/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 vote149 views1 answer
Set mysql socket file docker windows
SQL
3 votes171 views3 answers
Start postgresql ubuntu
SQL
0 vote149 views1 answer
Mariadb cast null to 0
SQL
0 vote156 views2 answers
Sql regex vowel
SQL
1 vote163 views1 answer
Mysql Case sum
SQL
1 vote154 views1 answer
Get create table query existing table mysql
SQL
4 votes144 views1 answer
Datepart postgres
SQL
3 votes156 views1 answer
Insert into table from another table mysql
SQL
0 vote169 views1 answer
Nuget sqllite-net-pcl
SQL
0 vote134 views3 answers
Joins and views sql
SQL

Share