Monday 22 May 2017

How to use LIKE conditions in MySQL?

MySQL LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards used in conjunction with the LIKE operator:
  • % - The percent sign represents zero, one, or multiple characters
  • _ - The underscore represents a single character
SELECT column1, column2,column3 FROM table_name WHERE columnN LIKE pattern; 


No comments:

Post a Comment

Advertisement

Advertisement