/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

1 vote299 views2 answers
Snowflake alter column data type
SQL
3 votes294 views1 answer
Select count from table mysql
SQL
1 vote269 views2 answers
End mysql command
SQL
0 vote276 views1 answer
How to check the port of mysql installation in mac
SQL
23 votes294 views6 answers
How to create table in sql
SQL
0 vote288 views1 answer
Postgresql get diff between two dates in Months
SQL
26 votes283 views2 answers
Mysql workbench download
SQL
2 votes274 views1 answer
Sql count having
SQL
0 vote282 views1 answer
Sql replace id with name from another table
SQL
1 vote292 views1 answer
Sql group by sum with condition
SQL

Share