Difference between LIKE and = in MYSQL?

by

= in SQL does exact matching.

LIKE does wildcard matching, using ‘%’ as the multi-character match symbol and ‘_’ as the single-character match symbol. ‘\’ is the default escape character.

foobar="$foo" and foobar LIKE '$foo' will behave the same, because neither string contains a wildcard.

foobar LIKE '%foo' will match anything ending in ‘foo’.

LIKE also has an ESCAPE clause so you can set an escape character. This will let you match literal ‘%’ or ‘_’ within the string. You can also do NOT LIKE.

The MySQL site has documentation on the LIKE operator. The syntax is 

expression [NOT] LIKE pattern [ESCAPE 'escape']

More Related Contents:

  1. convert mysql query to laravel query builder
  2. how to generate report for attendance system
  3. How can I return pivot table output in MySQL?
  4. MySQL pivot table query with dynamic columns
  5. ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)
  6. Finding duplicate values in MySQL
  7. Error installing mysql2: Failed to build gem native extension
  8. How to debug Lock wait timeout exceeded on MySQL?
  9. What is the most straightforward way to pad empty dates in sql results (on either mysql or perl end)?
  10. How to extract two consecutive digits from a text field in MySQL?
  11. Connect By Prior Equivalent for MySQL
  12. How to send email from MySQL 5.1
  13. MySQL skip first 10 results
  14. Import Data from Excel Spreadsheet or CVS into MySQL
  15. MySQL vs MongoDB 1000 reads
  16. How to convert all tables from MyISAM into InnoDB?
  17. How can I get rid of these comments in a MySQL dump?
  18. How to create relationships in MySQL
  19. MySQL error 1436: Thread stack overrun, with simple query
  20. Lost connection to MySQL server during query? [duplicate]
  21. Force InnoDB to recheck foreign keys on a table/tables?
  22. Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT
  23. Let MySQL users create databases, but allow access to only their own databases
  24. How can I enable MySQL’s slow query log without restarting MySQL?
  25. Does MySQL allows to create database with dot?
  26. Second SELECT query if first SELECT returns 0 rows
  27. MySQL Error: #1142 – SELECT command denied to user
  28. connecting to a docker-compose mysql container denies access but docker running same image does not
  29. MySQL’s lower_case_table_names won’t change
  30. Optimistic locking in MySQL

Leave a Comment