If SQL LIKE clause is used along with % characters then it will work like a meta character (*) in Unix while listing out all the files or directories at command prompt.
A D V E R T I S E M E N T
Without a % character LIKE clause is very similar to equal sign alongwith WHERE clause.
Example
string strParamSelect = @"SELECT * FROM myTable WHERE DESCRIPTION LIKE '%some description%'";
You can specify any condition using WHERE clause.
You can use LIKE clause alongwith WHERE clause.
When LIKE is used alongwith % sign then it will work like a meta character search.
You can specify more than one conditions using AND or OR operators.
A WHERE clause with equal sign (=) works fine where we want to do an exact match. Like if "tutorial_author = 'Sanjay'". But there may be a requirement where we want to filter out all the results where tutorial_author name should contain "jay". This can be handled using SQL LIKE clause alongwith WHERE clause.
SELECT field1, field2,...fieldN table_name1, table_name2...
WHERE field1 LIKE condition1 [AND [OR]] filed2 = 'somevalue'
Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.
Keywords:
MySQL Like Clause, Mysql Tutorial, Mysql tutorial pdf, history of mysql, basic mysql, syntax use in mysql, mysql software download, learn mysql, mysql insert, mysql delete, mysql data types, mysql administrator.
