sql - Performance of querying for a string that starts and ends with something

Question

Are there any performance difference in querying a database for some character column starting with something and ending with something?

SELECT * FROM table WHERE column like '%something'
SELECT * FROM table WHERE column like 'something%'

Any downsides to choose one approach instead of another? Disregarding the user need for matching the start or end of a word.
The way it is implemented maybe the algorithms differ in some way?

Answer 1

Instead of creating a new column and index to deal with the

SELECT * FROM table WHERE column like '%something'

query, you could create an index

CREATE INDEX rev_col_idx ON table (reverse(column) text_pattern_ops);

and then rewrite the above query as

SELECT * FROM table WHERE reverse(column) like reverse('%something')

which will achieve the same thing.