Query that ignore the spaces

by 
SELECT * FROM mytable 
    WHERE REPLACE(username, ' ', '') = REPLACE("John Bob Jones", ' ', '')

More Related Contents:

  1. How to check if a table exists in a given schema
  2. How to select the nth row in a SQL database table?
  3. In MySQL queries, why use join instead of where?
  4. PostgreSQL GROUP BY different from MySQL?
  5. Transpose latest rows per user to columns
  6. MySQL dump by query
  7. single fixed table with multiple columns vs flexible abstract tables
  8. SQLite – ORDER BY RAND()
  9. SQL – How to transpose?
  10. How can I send email from PostgreSQL trigger?
  11. SQL Between clause with strings columns
  12. MySQL equivalent of DECODE function in Oracle
  13. Insert an image in postgresql database
  14. How to delete Duplicates in MySQL table
  15. Why do NULL values come first when ordering DESC in a PostgreSQL query?
  16. How do I alter the position of a column in a PostgreSQL database table?
  17. How to find a table having a specific column in postgresql
  18. How to Optimize Queries in a Database – The Basics
  19. INSERT COMMAND :: ERROR: column “value” does not exist
  20. MySQL – how to front pad zip code with “0”?
  21. Bulk/batch update/upsert in PostgreSQL
  22. How to show row numbers in PostgreSQL query?
  23. Postgres Error: More than one row returned by a subquery used as an expression
  24. Create date from day, month, year fields in MySQL
  25. Grant privileges for a particular database in PostgreSQL
  26. Upsert with a transaction
  27. How to compare dates in datetime fields in Postgresql?
  28. PostgreSQL how to create a copy of a database or schema?
  29. Temporal database design, with a twist (live vs draft rows)
  30. Postgres: convert single row to multiple rows (unpivot)

Leave a Comment