Best way to test if a row exists in a MySQL table

You could also try EXISTS:

SELECT EXISTS(SELECT * FROM table1 WHERE ...)

and per the documentation, you can SELECT anything.

Traditionally, an EXISTS subquery starts with SELECT *, but it could begin with SELECT 5 or SELECT column1 or anything at all. MySQL ignores the SELECT list in such a subquery, so it makes no difference.

Related Posts:

  1. MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
  2. What’s the best way to search for a UPC code in a Database?
  3. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  4. Unknown column in ‘field list’ error on MySQL Update query
  5. Unknown column in ‘field list’ error on MySQL Update query
  6. MySQL – Operand should contain 1 column(s)
  7. When should I use CROSS APPLY over INNER JOIN?
  8. MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
  9. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  10. MySQL create table if not exists and insert record only if table was created
  11. How do I use properly CASE..WHEN in MySQL
  12. How can I do a FULL OUTER JOIN in MySQL?
  13. MySQL query String contains
  14. What’s the difference between VARCHAR and CHAR?
  15. Case statement in MySQL
  16. How to declare a variable in MySQL?
  17. MySQL Cannot Add Foreign Key Constraint
  18. How to split the name string in mysql?
  19. How do I import an SQL file using the command line in MySQL?
  20. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  21. mysql Foreign key constraint is incorrectly formed error
  22. MySQL: Invalid use of group function
  23. How can I return pivot table output in MySQL?
  24. Compare dates in MySQL
  25. MySQL “WITH” clause
  26. MySQL Multiple Joins in one query?
  27. Error Code: 2013. Lost connection to MySQL server during query
  28. MySQL syntax for Join Update
  29. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
  30. how to drop partition without dropping data in MySQL?
  31. MySQL combine two columns into one column
  32. Simple way to calculate median with MySQL
  33. Error 1046 No database Selected, how to resolve?
  34. MySQL Error 1264: out of range value for column
  35. Count(*) vs Count(1) – SQL Server
  36. Remove duplicate rows in MySQL
  37. How to SUM and SUBTRACT using SQL?
  38. Cast from VARCHAR to INT – MySQL
  39. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  40. How do you force mysql LIKE to be case sensitive?
  41. MySQL – UPDATE multiple rows with different values in one query
  42. How to create a MySQL hierarchical recursive query?
  43. ERROR 1148: The used command is not allowed with this MySQL version
  44. Insert into a MySQL table or update if exists
  45. How to round down to nearest integer in MySQL?
  46. MySQL starts with searching issue
  47. Query to convert from datetime to date mysql
  48. Is it possible to GROUP BY multiple columns using MySQL?
  49. MySQL error: key specification without a key length
  50. Check if MySQL table exists without using “select from” syntax?
  51. MySQL equivalent of DECODE function in Oracle
  52. mysql update column with value from another table
  53. The used SELECT statements have a different number of columns
  54. How to delete from multiple tables in MySQL?
  55. MySQL: Can’t create table (errno: 150)
  56. How to copy a row and insert in same table with a autoincrement field in MySQL?
  57. Join vs. sub-query
  58. Alternative to except in MySQL
  59. Equivalent of explode() to work with strings in MySQL
  60. ROW_NUMBER() in MySQ
  61. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  62. MySQL OPTIMIZE all tables?
  63. MySQL – Get row number on select
  64. MySQL error: Unknown column in ‘where clause’
  65. How to truncate the text returned for a column in a MySQL query
  66. Using union and order by clause in mysql
  67. MySQL LIKE IN()?
  68. What’s the best way to dedupe a table?
  69. WP Optimization: Removing Orphaned wp_options (especially the autoload ones)
  70. Debugging WordPress
  71. This SQL request call all time and overload my server : SELECT meta_value FROM wp_sitemeta WHERE meta_key = ‘wp_installer_network’ AND site_id = 1
  72. Using group by on multiple columns
  73. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  74. How can I do ‘insert if not exists’ in MySQL?
  75. What does Include() do in LINQ?
  76. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  77. Get everything after and before certain character in SQL Server
  78. WordPress SQL LIKE request doesn’t work for fields with special symbols
  79. Concurrent / simultaneous MySQL connections
  80. WordPress plugin overloading with tmp tables
  81. WordPress SQL Issue not returning correct reselts
  82. Inner Join user tables to select users with roles
  83. $wpdb->prepare with LIKE returning blank array instead of rows
  84. Removing posts by sql
  85. Why line returns are not reapply after doing esc_sql?
  86. Show Mysql table elements as pages in WordPress
  87. Minimize Performance Issues of MultiSite Large Number of Tables Created
  88. Data is not constatntly loading from custom wordpress table
  89. Search results sort order failing: set by date only
  90. Delete oldest wordpress post (SQL query)
  91. Delete all users meta that named: user_avatar
  92. An SQL query to find orphaned image attachments and their meta
  93. Bulk Change WordPress category Slug
  94. Performance of wp_get_attachment_image_srcset() and wp_get_attachment_image_url()
  95. optimise SQL wordpress call
  96. SQL to transform all email addresses in my DB in lowercase [closed]
  97. Get all the related data from WordPress DB
  98. How to write inner join using posts_clauses?
  99. why you don’t Implement PDO for access every thing to database
  100. Deleting WordPress posts and media files based on author via MYSQL database

Leave a Comment