MySQL INSTR Function: Examples

SELECT INSTR('MySQL INSTR', 'MySQL');

SELECT INSTR('MySQL INSTR', 'mysql');

SELECT INSTR('MySQL INSTR', BINARY 'mysql');

SELECT 
    productName
FROM
    products
WHERE
    INSTR(productname,'Car') > 0;

SELECT 
    productname
FROM
    products
WHERE
    productname LIKE '%Car%';

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;