ORACLE SQL TUTORIAL: How to get rows containing a string | LIKE and NOT LIKE

Опубликовано: 04 Март 2022
на канале: FileTech en

How to get rows that containing a string

Code:
-- results that contain
select * from tablename
where columname like '%Value%';

--Results that contain salts and bring everything from
select * from tablename
where columname like '%Value';

--Results containing Sales and bring everything forward
select * from tablename
where columname like 'Value%';

-- NOT LIKE
-- the same, but exclude that result
select * from tablename
where columname not like '%Value%'; -- it is not Trade

select * from tablename
where columname not like '%Value'; -- not show Sales

select * from tablename
where columname not like 'Value%';

👉 ACCESS webpage ►
https://www.filetechn.com

★NETWORKS (FOLLOW US)★
►Facebook: / filetechn
►Group Facebook: / 2356934024596866
►Telegram: https://t.me/filetech

★DOWNLOAD OUR APPS FOR ANDROID★
► https://play.google.com/store/apps/de...

Remember that these videos are for educational purposes.