How to have a SQLite query with a variable part?

Question

Hi I am trying to create a query for SQLite which has a variable part in it. By variable I mean that a certain part within the string can possibly contain a variable but also an empy value

I tried this but I am not sure whether this works.

SELECT * FROM table WHERE attr LIKE 'ABC% %DEF'

If you are certain about your leading and lagging characters then use attr LIKE 'ABC%DEF' for anything in between including spaces. — VTi
– VTi, Commented Jun 11, 2020 at 13:58
Okay so a single % will do the job? Thanks! I am unsure because I am preparing some queries atm for tables that dont exist rn ^^ — 0xDr0id
– 0xDr0id, Commented Jun 11, 2020 at 14:03

VTi · Accepted Answer · 2020-06-11 14:17:47Z

1

Adding onto my comment, check the below code to test your values.

SELECT CASE WHEN 'ABC G DEF' LIKE 'ABC%DEF'
            THEN 1
            ELSE 0 END as test_space,
       CASE WHEN 'ABCGGGDEF' LIKE 'ABC%DEF'
            THEN 1
            ELSE 0 END AS test_all

answered Jun 11, 2020 at 14:17

VTi

1,3298 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to have a SQLite query with a variable part?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related