0

I am working with a product database and i need to select products that are greater than £150 also only entries that have "HP" in the third and forth position of the prod_id.

So far i have tried

SELECT * FROM products WHERE prod_id LIKE 'hp%';

Here is a pic of the table i need to query

enter image description here

basgys
  • 4,320
  • 28
  • 39
Jmac88
  • 91
  • 1
  • 3
  • 14

2 Answers2

2
SELECT * FROM products WHERE prod_id LIKE '__hp%' and price > 150;

"_" (underscore) is any symbol (there are 2 undrscores in this query)

Multisync
  • 8,657
  • 1
  • 16
  • 20
2

An underscore will match a single character.

So:

SELECT * FROM products 
WHERE prod_id LIKE '__hp%'
AND price > 150;

Should find all products whos 3rd and 4th character are hp and have a price of 150 or more

crthompson
  • 15,653
  • 6
  • 58
  • 80