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
LeetCode 262
1
distinct on vs row_number
funkcia_transakcie
FINALE fdjfnkds
SQL Moving Rating Practice by Han Wang 20200720
Postgres CrossTab for query with variable number of columns
Transform sequential key value data to row based key value data
Return IDs where there are exactly 3 occurrences
tegs and users