Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: pattern-matching

Pattern matching with LIKE, SIMILAR TO or regular expressions in PostgreSQL

By adminPosted on December 24, 2022

Question : I had to write a simple query where I go looking for people’s name that start with a […]

PostgreSQL LIKE query on ARRAY field

By adminPosted on December 12, 2022

Question : Is there any way to have a Postgres LIKE query on a ARRAY field? Currently I want something […]

Trying to check if a string contains a number exclusively

By adminPosted on November 27, 2022

Question : I have been trying to write a function to check if a string contains a number without that […]

PostgreSQL 8.4 no levenshtein fuzzymatching?

By adminPosted on November 21, 2022

Question : I’m using debian squeeze package, it says function does not exist? Answer : You have to install the […]

PostgreSQL full text search on many columns

By adminPosted on November 8, 2022

Question : I need an advice with searching of record based on specified string. Search strings can contain values from […]

Postgres trigram match acting strange for specific characters

By adminPosted on November 3, 2022

Question : I’m using pg_trgm to run a query, but I’m getting a lot of 1 matches when searching with […]

MATCH AGAINST one character words returns empty rows with ft_min_word_len = 1

By adminPosted on September 30, 2022

Question : I’ve set ft_min_word_len = 1 to my.cnf file, also SHOW VARIABLES LIKE ‘ft_min_word%’ displays ft_min_word_len as 1. Then […]

Full text search in PostgreSQL with search term including unrelated hyphen and ending

By adminPosted on September 22, 2022

Question : I’ve a problem in my DB (PGSQL 9.6) that I’ve not been able to resolve and I don’t […]

Replace a sequential set of numbers with special character

By adminPosted on September 13, 2022

Question : I have a varchar(200) column that contains entries such as, ABC123124_A12312 ABC123_A1212 ABC123124_B12312 AC123124_AD12312 A12312_123 etc.. I want […]

Oracle equivalent to MS-Access character range/set

By adminPosted on August 14, 2022

Question : In MS-Access, I can use character ranges/sets in the where clause: SELECT table_name FROM all_tab_columns WHERE table_name NOT […]

  • 1
  • 2
  • 3
  • …
  • 5

Recent Posts

  • Help me define the tables in this scenario
  • Convert seconds into HH:MM:SS format in MySQL
  • Guaranteeing a FK relationship through multiple tables
  • Is it Possible to Recover Data from a BLACKHOLE table? [closed]
  • MySQL: sysbench test – InnoDB vs Memory tables
  • Why are virtual log files not always allocated in order?
  • Need help to understand how information_schema.TABLES get updated
  • unique constraint on a set
  • PostgreSQL, integer arrays, index for equality
  • What is the most performant way to group by and join high cardinality columns in column based table?
  • LOAD DATA (400k rows) INFILE takes about 7 minutes, cannot kill the “logging slow query” process?
  • Is a process created in Oracle for every SQL statement?
  • How to select a row based on the maximum value of a column, when ties are expected
  • I am unable to join tables in correct manner
  • How often to backup database and what are the favoroble practices to do so [closed]
  • In Postgresql, after pg_dump the access privileges on the database itself are not restored
  • InnoDB Buffer pool not showing as much I configured in MariaDB 10.5
  • Which version of SQL Server 2016 supports R
  • Design DB for users with different information fields?
  • WSREP: Writeset deserialization failed: Unsupported RecordSet version: 2: 71 (Protocol error)

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding