like in mysql
SELECT name FROM products WHERE name LIKE '%Value1' OR name LIKE '%Value2';like in mysql
SELECT name FROM products WHERE name LIKE '%Value1' OR name LIKE '%Value2';MySQL LIKE
The LIKE operator is a logical operator that tests whether a string contains a specified pattern or not. Here is the syntax of the LIKE operator:
expression LIKE pattern ESCAPE escape_character
This example uses the LIKE operator to find employees whose first names start with a:
SELECT
employeeNumber,
lastName,
firstName
FROM
employees
WHERE
firstName LIKE 'a%';
This example uses the LIKE operator to find employees whose last names end with on e.g., Patterson, Thompson:
SELECT
employeeNumber,
lastName,
firstName
FROM
employees
WHERE
lastName LIKE '%on';
For example, to find all employees whose last names contain on , you use the following query with the pattern %on%
SELECT
employeeNumber,
lastName,
firstName
FROM
employees
WHERE
lastname LIKE '%on%';mysql like in
SELECT * from fiberbox where field REGEXP '1740|1938|1940';sql like
eturns true if the operand value matches a pattern.
Example: Returns true if the user’s first_name ends with ‘son’.
SELECT * FROM users
WHERE first_name LIKE '%son';Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
