/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

25 votes369 views3 answers
How to use a database to see tables mysql
SQL
0 vote338 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote333 views1 answer
Backup a table in sql
SQL
1 vote416 views1 answer
Ora-06502: pl/sql: numeric or value error: character string buffer too small
SQL
0 vote362 views1 answer
Sql file in postgres with pgadmin
SQL
0 vote377 views1 answer
Local pg_sql to heroku pg_sql
SQL
1 vote339 views1 answer
Create table variable in sql stored procedure
SQL
2 votes366 views1 answer
Find all triggers in database
SQL
1 vote373 views1 answer
Where not in array sql
SQL
0 vote453 views1 answer
How to rename a database in tsql
SQL

Share