CODEWITHSUNDEEP
androidsqlite
Rendy
Rendy

Reputation: 5698

How to query first letter of each words consecutively in sqlite?

I want to get the result of matched first letter of each words consecutively in sqlite.

For example I have data as following:

  • That Lucky Old Sun
  • Today My Life Begins

When I type tl, I want That Lucky Old Sun as the only result. I have done this command:

select * from table_name where column_name LIKE 't% l%'

but both data come out as the result.

Anyone can advise me how to done this query? Thanks!

Upvotes: 1

Views: 1220

Answers (1)

stinepike
stinepike

Reputation: 54672

you can try using this

select * from table_name where column_name LIKE 't% l%' AND NOT LIKE 't% % l%'

Upvotes: 2

Related Questions