/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 vote120 views1 answer
Possgress drop if exists view
SQL
0 vote133 views1 answer
Mariadb cast null to 0
SQL
1 vote125 views1 answer
Mysql check if string contains comma separated
SQL
0 vote141 views1 answer
TSQL function split string
SQL
1 vote146 views3 answers
Mysql on delete set null
SQL
2 votes132 views2 answers
Postgres select duplicate columns
SQL
1 vote129 views1 answer
Mysql select row max date
SQL
1 vote140 views1 answer
Change table to innodb mysql
SQL
0 vote127 views1 answer
Sql convert datetime to year
SQL
0 vote128 views1 answer
Oarcale list objects
SQL

Share