/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 vote133 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote139 views1 answer
Drop all triggers oracle
SQL
0 vote147 views2 answers
Unique key
SQL
0 vote160 views1 answer
Mysql last friday of current month
SQL
0 vote145 views1 answer
Sql server for loop
SQL
15 votes162 views6 answers
Drop foreign key mysql
SQL
1 vote134 views1 answer
Oracle duration between timestamps
SQL
0 vote176 views1 answer
Ms sql print more than 1 variable
SQL
0 vote140 views3 answers
CONTACT FORM SQL
SQL
1 vote211 views1 answer
Oracle create program if not exists
SQL

Share