No Featured Found!
How to make WHERE col LIKE '%' select NULL values too?
When we apply LIKE keyword to any query then it doesn't return NULL values, and sometimes it required to return NULL values as well. We can do this by using IS NULL or IFNULL operator. Example: We have a table "employee" as be...
What is the use of LIKE Operator in MySQL?
In MySQL, the LIKE operator is used to search for a specified pattern for a column in a WHERE clause . LIKE Syntax SELECT column_name FROM table_name WHERE column_name LIKE pattern; We have a table "employee" as below: employe...