I have the next query:
SELECT COUNT(*)
FROM inventory.items as itms
WHERE itms.id LIKE 'intel%' OR
itms.description LIKE 'intel%' OR
itms.barcode LIKE 'intel%'
and I just got the next error:
ERROR: operator does not exist: integer ~~ unknown
LINE 3: WHERE itms.id LIKE 'intel%' OR
^
HINT: No operator matches the given name and argument types. You might need to add explicit type casts.
SQL state: 42883
Character: 63
Am I missing something?