I'm trying to search a Postgres table using LIKE and %, but the query is not returning results.
local_username will contains values formatted like:
My query is searching this one column based on both the
username and domain sections.
An example query is below:
SELECT * FROM users WHERE local_username LIKE 'username%' AND local_username LIKE '%domain%';
I'm concerned that, because there may be no characters after domain in the query, the second % is going to cause it to not return any results, since the % causes it to search for more characters, which in the case of the above query are not present.
Is there another keyword other than LIKE that I should be using? Or do I need to check each possibility (example below).
SELECT * FROM users WHERE local_username LIKE 'username%' AND (local_username LIKE '%domain%' OR local_username LIKE '%domain');