How to do custom search in MySQL?

Question

Aryan Kumar · Answer

Sure, you can do custom search in MySQL using the LIKE operator. The LIKE operator allows you to search for a pattern in a column. The syntax is as follows:

SQL

SELECT *
FROM table_name
WHERE column_name LIKE pattern;

The pattern can be a regular expression or a simple string. For example, the following SQL statement will search for all rows in the products table where the name column contains the word "product":

SQL

SELECT *
FROM products
WHERE name LIKE '%product%';

The % character is a wildcard that matches any number of characters. So, the LIKE operator will match all rows where the name column contains the word "product", regardless of whether the word is at the beginning, end, or middle of the column.

Here is an example of how to do custom search in MySQL:

SQL

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300),
('Product 4', 400),
('Product 5', 500);

SELECT *
FROM products
WHERE name LIKE '%product%';

This will return the following result:

id | name | price
------+------+-------
1 | Product 1 | 100
2 | Product 2 | 200
3 | Product 3 | 300
4 | Product 4 | 400
5 | Product 5 | 500

As you can see, the LIKE operator has matched all rows where the name column contains the word "product".

Here are some additional things to keep in mind when using the LIKE operator:

The LIKE operator is case-insensitive by default.
You can use the ESCAPE keyword to escape special characters, such as the % character.
You can use the BINARY keyword to make the LIKE operator case-sensitive.

forum

How to do custom search in MySQL?

Can you answer this question?

1 Answers