Новый курс! Каждый программист должен знать генеративный ИИ!
Попробуйте бесплатный урок0
Oracle UPPER with the SQL LIKE
How to incorporate the Oracle UPPER function with the SQL LIKE condition? I'm trying to query against a free text field for all records containing the word "test". The problem is that it can be entered in the following ways: TEST, Test, or test.
2 ответов
+ 1
SELECT *
FROM Table
WHERE UPPER(column) LIKE UPPER('%test%')
Did you try something like this?
0
nope let me try