#不区分大小写,但是区分空格
SELECT prodid,prodname FROM products WHERE prod_name LIKE ‘Fish%’;
SELECT prod_id,prod_name FROM products WHERE prod_name LIKE “%bean bag%”;
SELECT prod_id,prod_name FROM products WHERE prod_name LIKE ‘F%y’;
SELECT cust_email FROM customers WHERE cust_email LIKE ‘%@fun4all.com’;
#%可以匹配空格,但是不能匹配NULL
#x下划线
SELECT prod_id,prod_name FROM products WHERE prod_name LIKE ‘ inch teddy bear’;
SELECT prod_id,prod_name FROM products WHERE prod_name LIKE ‘% inch teddy bear’;