On Apr 6, 2017 05:57, "Patrick B" <patrickbakerbr(at)gmail(dot)com> wrote:
Hi guys,
i've got this column:
path_name character varying(255)
>
I store full S3 bucket path for the attachments of my application on it;
example:
/{s3bucket}/filesuser/client/27801123/attachment/4510/main
>
/{s3bucket}/filesuser/client/27801123/attachment/4510/file
>
I wanna do a select, where path_name has only 'main' and not anything else.
WHERE path_nane LIKE '%/main'