/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

6 votes156 views1 answer
Allsource oracle
SQL
16 votes151 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
2 votes141 views1 answer
Mysql select random id from table
SQL
3 votes146 views1 answer
Select count from table mysql
SQL
0 vote147 views1 answer
How to delete python anywhere mysql database
SQL
0 vote305 views1 answer
Dublicate row sql
SQL
0 vote102 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote166 views1 answer
Set open file limit mac catalina mysql
SQL
2 votes172 views2 answers
Install postgresql
SQL
0 vote155 views1 answer
Datagrip execute procedure
SQL

Share