Sql

Search

sql ends with string

-- Case insensitive
SELECT * FROM my_table WHERE upper(my_column) LIKE 'SEARCHED %';  -- starts with
SELECT * FROM my_table WHERE upper(my_column) LIKE '% SEARCHED';  -- ends with
SELECT * FROM my_table WHERE upper(my_column) LIKE '%SEARCHED%';  -- contains

Comment

PREVIOUS	NEXT

Code Example
Sql :: get date from timestamp in mysql
Sql :: use of now() in mysql
Sql :: this week mysql
Sql :: sQL query to get all table records count from a database
Sql :: mysql check db size
Sql :: sql show tables
Sql :: how to reset table in sql server
Sql :: sql last updated
Sql :: oracle sessions_per_user
Sql :: mysql config user password
Sql :: python mysql query to dataframe
Sql :: wordpress print query sql
Sql :: get row affected mysql
Sql :: sql remove not null constraint
Sql :: how to check xampp mysql password
Sql :: oracle tables with column name
Sql :: sql create a new table
Sql :: sql values not in another table
Sql :: date formats in sql server
Sql :: SQL loop with cursor
Sql :: sql server update column based on another table
Sql :: temp table sql
Sql :: sql unique rows
Sql :: how to get duplicate records with multiple field in sql
Sql :: how to rename a database in tsql
Sql :: oracle show column of table
Sql :: postgres check for foreign key
Sql :: oracle create table auto generated primary key
Sql :: sql query to list all tables in a database sql server
Sql :: date format in postgresql

Search

SQL

sql ends with string

ADD CONTENT