


GORM multi-column fuzzy query and deletion mark conflict: How to avoid querying deleted records?
Apr 02, 2025 pm 04:30 PMSolutions to conflict between GORM multi-column fuzzy query and soft deletion
When using GORM for database operations, multiple columns of fuzzy queries and soft deletion filtering are often required at the same time. If handled incorrectly, it may cause the query results to contain deleted records. This article will explain how to effectively avoid this situation.
Question: Suppose you need to fuzzy match username
and nickname
columns according to the keywords, and exclude records with is_del
of 1 (deleted). Using where
and or
methods directly to combine queries may result in errors.
Error example:
_db = _db.Where("username like ?", "%" keyword "%").Or("nickname like ?", "%" keyword "%")
The above code uses Or
method, resulting in that even if is_del
is 1, the record will be queryed as long as username
or nickname
matches the keyword.
Solution: Merge all the conditions into one Where
statement:
_db = _db.Where(" (username LIKE ? OR nickname LIKE ?) AND is_del = ?", "%" keyword "%", "%" keyword "%", 0)
The improved code combines the fuzzy matching conditions of username
and nickname
using brackets and concatenates with is_del = 0
using AND
conditions. In this way, only records that meet the fuzzy matching and undeletion conditions will be queried, effectively avoiding the incorrect check of soft deleted records.
Through this method, it is possible to ensure that GORM multi-column fuzzy query and soft deletion conditions take effect at the same time, thereby obtaining accurate query results. Remember to use brackets to ensure operator priority and avoid logical errors.
The above is the detailed content of GORM multi-column fuzzy query and deletion mark conflict: How to avoid querying deleted records?. For more information, please follow other related articles on the PHP Chinese website!

Hot AI Tools

Undress AI Tool
Undress images for free

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Clothoff.io
AI clothes remover

Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics











TointegrateGolangserviceswithexistingPythoninfrastructure,useRESTAPIsorgRPCforinter-servicecommunication,allowingGoandPythonappstointeractseamlesslythroughstandardizedprotocols.1.UseRESTAPIs(viaframeworkslikeGininGoandFlaskinPython)orgRPC(withProtoco

Golangofferssuperiorperformance,nativeconcurrencyviagoroutines,andefficientresourceusage,makingitidealforhigh-traffic,low-latencyAPIs;2.Python,whileslowerduetointerpretationandtheGIL,provideseasierdevelopment,arichecosystem,andisbettersuitedforI/O-bo

Golang is mainly used for back-end development, but it can also play an indirect role in the front-end field. Its design goals focus on high-performance, concurrent processing and system-level programming, and are suitable for building back-end applications such as API servers, microservices, distributed systems, database operations and CLI tools. Although Golang is not the mainstream language for web front-end, it can be compiled into JavaScript through GopherJS, run on WebAssembly through TinyGo, or generate HTML pages with a template engine to participate in front-end development. However, modern front-end development still needs to rely on JavaScript/TypeScript and its ecosystem. Therefore, Golang is more suitable for the technology stack selection with high-performance backend as the core.

TocompletelyuninstallGolang,firstdeterminehowitwasinstalled(packagemanager,binary,source,etc.),thenremoveGobinariesanddirectories,cleanupenvironmentvariables,anddeleterelatedtoolsandcaches.Beginbycheckinginstallationmethod:commonmethodsincludepackage

In Go, if you want the structure field to use a custom field name when converting to JSON, you can implement it through the json tag of the structure field. 1. Use the json: "custom_name" tag to specify the key name of the field in JSON. For example, Namestringjson: "username"" will make the Name field output as "username"; 2. Add, omitempty can control that the output is omitted when the field is empty, such as Emailstringjson: "email,omitempty""

The key to installing Go is to select the correct version, configure environment variables, and verify the installation. 1. Go to the official website to download the installation package of the corresponding system. Windows uses .msi files, macOS uses .pkg files, Linux uses .tar.gz files and unzip them to /usr/local directory; 2. Configure environment variables, edit ~/.bashrc or ~/.zshrc in Linux/macOS to add PATH and GOPATH, and Windows set PATH to Go in the system properties; 3. Use the government command to verify the installation, and run the test program hello.go to confirm that the compilation and execution are normal. PATH settings and loops throughout the process

TogetenvironmentvariablesinGo,useos.Getenv(),butconsiderLookupEnvforexistencechecks.1.Useos.Getenv("VAR_NAME")toretrieveavariable’svalueasastring,returningemptyifunset.2.Useos.LookupEnv()todistinguishbetweenunsetandemptyvariables.3.Provided

"Go:commandnotfound" is usually caused by incorrect configuration of environment variables; 1. Check whether Go has been installed correctly and use whichgo to confirm the path; 2. Manually add Go's bin directory (such as /usr/local/go/bin) to the PATH environment variable; 3. Modify the corresponding shell's configuration file (such as .bashrc or .zshrc) and execute source to make the configuration take effect; 4. Optionally set GOROOT and GOPATH to avoid subsequent module problems. After completing the above steps, run government and verify whether it is repaired.
