{"id":3552,"date":"2022-08-11T13:10:20","date_gmt":"2022-08-11T13:10:20","guid":{"rendered":"http:\/\/kevinbk.com\/?p=3552"},"modified":"2022-08-11T14:49:28","modified_gmt":"2022-08-11T14:49:28","slug":"filtrar-por-colunas-identicas-em-bancos-de-dado-com-sql-query","status":"publish","type":"post","link":"https:\/\/kevinbk.com\/en\/filter-by-identical-columns-in-databases-with-sql-query\/","title":{"rendered":"Filter by Identical Columns in Databases with SQL Query"},"content":{"rendered":"
Looking for a way to filter your rows from a SQL, MySQL or MariaDB database table by identical columns? Looking for a Query to play on console? <\/p>\n\n\n\n
I recently went through a situation where it was necessary to filter on a database table and only display rows that had two columns with the same text values. After hours of searching I found the simple solution and I'm sharing it with you. <\/p>\n\n\n\n
I'm no programmer, and I believe that most people looking for these tips don't have that much sense of code either. <\/p>\n\n\n\n
I often use the Navicat program to edit databases, it is quite fast and practical, in addition to allowing you to edit rows and columns with equal freedom to Microsoft Excel or Apple Numbers.<\/p>\n\n\n\n
Most people use PhpmyAdmin to manage their website's databases. Both allow you to run scripts through the SQL or Query tab. <\/p>\n\n\n\n
As I'm no database professional, I didn't know that you can display filtered tables through a query code, but luckily I found out. <\/p>\n\n\n\n
My use in the database is entirely to delete lines, look for texts and use the Search and Replace<\/strong><\/em>, I had no idea that SQL codes are super useful. <\/p>\n\n\n\n I have personally used these codes to check for translation errors and find untranslated rows in the database tables of translate press<\/a>. <\/p>\n\n\n