Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Query for matching substring from text field in DB
--PostgreSQL 9.6 --'\\' is a delimiter CREATE TABLE mmytable (title character varying) ; INSERT INTO mmytable (title) VALUES ('#Samsung Co.'), ('They have a phone#'), ('Uncle Sam phoned him') ; select * from mmytable where title ~* '(?<!\w)(?:#samsung|phone#)(?!\w)';
run
|
edit
|
history
|
help
0
funkcia_transakcie
Assignment
postgresql timestamp
SQL hierarchical query. branch of responses.
FlujoPadre
Professional Networking Social Media Website SQL Analysis
1127. User Purchase Platform
Pedido_Insert_Delete
FInale 38474297439
Assignment 1(SET A)