Home » SQL Basics » Retrieving Data » Using LIKE

Using LIKE

Using LIKE

Syntax: Select “column_name1″, “column_name2″,….”column_nameZ” FROM “table_name” where name like ‘John’

Example: Example: SELECT name, age FROM employee where name like ‘John’

In the above example it only displays all employees whose name is John.

Leave a Reply

Your email address will not be published. Required fields are marked *