Select Data Using Like From MySQL Tutorial Example

How To Select Data Using Like From MySQL Tutorial Example

Open your MySQL Query Editor then copy & paste the below code to select or retrive rows data using LIKE from a database table "test" in MySQL Database Server

-- How To Select Data Using Like From MySQL Tutorial Example

SELECT * FROM test WHERE TestName LIKE '%Do%';

-- that's it!! all rows and all columns of mysql database table "test"
-- whose Name has the string "Do" have been selected
      -- is comment in MySQL
      -- in fact it is comment in MSSQL and Oracle as well
   

How To Select Data Using Like From MySQL Tutorial Example - Result in MySQL Query Editor

 

Related Tutorial Examples

  1. MySQL IFNULL() Function Datetime Example
  2. MySQL IFNULL() Nested Function Example
  3. MySQL IFNULL() Function String Example
  4. MySQL IFNULL() Function Number Example
  5. MySQL IFNULL() Function Boolean Example
  6. SELECT specific columns using SQL Command MySQL Example
  7. MySQL Stored Procedure: Batch Salary Increment Example
  8. 20 steps to make CakePHP Blog Project

No comments:

Post a Comment

leave your comments here..