ORACLE SQL TUTORIAL: How to get rows containing a string | LIKE and NOT LIKE
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.
Watch video ORACLE SQL TUTORIAL: How to get rows containing a string | LIKE and NOT LIKE online without registration, duration hours minute second in high quality. This video was added by user FileTech en 04 March 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 34 once and liked it 0 people.