Postgresql SELECT if string contains

Question

So I have a  in my Postgresql   TAG TABLE                            id            tag name        -------------------------- 1             aaa 2             bbb 3             ccc   To simplify my problem  What I want to do is SELECT  id  from TAG TABLE when a string  aaaaaaaa  contains the  tag name   So ideally  it should only return  1   which is the ID for tag name  aaa   This is what I am doing so far   SELECT id FROM TAG TABLE WHERE  aaaaaaaaaaa  LIKE   tag name     But obviously  this does not work  since the postgres thinks that   tag name   means a pattern containing the substring  tag name  instead of the actual data value under that column   How do I pass the tag name to the pattern

User · Answer

In addition to the solution with  aaaaaaaa  LIKE        tag name        there are position  reversed order of args  and strpos   SELECT id FROM TAG TABLE WHERE strpos  aaaaaaaa   tag name   gt  0   Besides what is more efficient  LIKE looks less efficient  but an index might change things   there is a very minor issue with LIKE  tag name of course should not contain   and especially    single char wildcard   to give no false positives

User · Answer

I personally prefer the simpler syntax of the   operator   SELECT id FROM TAG TABLE WHERE  aaaaaaaa    tag name    Worth reading through Difference between LIKE and   in Postgres to understand the difference

User · Answer

You should use  tag name  outside of quotes  then its interpreted as a field of the record  Concatenate using      with the literal percent signs   SELECT id FROM TAG TABLE WHERE  aaaaaaaa  LIKE        tag name

User · Answer

SELECT id FROM TAG TABLE WHERE  aaaaaaaa  LIKE         tag name            tag name should be in quotation otherwise it will give error as tag name doest not exist

User · Answer

A proper way to search for a substring is to use position function instead of like expression  which requires escaping      and an escape character    by default    SELECT id FROM TAG TABLE WHERE position tag name in  aaaaaaaaaaa   gt 0

[sql] Postgresql SELECT if string contains

Examples related to sql

Examples related to postgresql