/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 vote282 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote273 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
1 vote268 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
0 vote333 views1 answer
How to compile a function in oracle
SQL
1 vote296 views1 answer
How to start with sql
SQL
1 vote295 views1 answer
Pl sql insert into table
SQL
23 votes313 views4 answers
How to show all users in mysql
SQL
5 votes330 views1 answer
Oracle get ddl
SQL
2 votes302 views1 answer
Datetrunc
SQL
6 votes275 views2 answers
Can't connect to local mysql server through socket
SQL

Share