[SOLVED] Whats the difference?

[le007]

WHERE (`type` like 'car')

and

WHERE (`type` like '%car%')

?

[kernelgpf]

The percent signs make it so the word containing "car" can have surrounding characters.. the first would find something where type= "a car is cool" and the second could also find "racecars are awesome", whereas the first couldn't.

[le007]

I have 2 different "types" - one is car and the other is caravan

 

How can I make it just "car" is searched for?

 

thanks!

[GingerRobot]

The percent signs make it so the word containing "car" can have surrounding characters.. the first would find something where type= "a car is cool" and the second could also find "racecars are awesome", whereas the first couldn't.

 

Actually, the first query would not match your first example. It would only match the exact text 'car'. It is no different from a query such as: WHERE `type` = 'car'

 

le007: fyi, the % character is used to match any number of any character. You can use the underscore character to match any character, but just once.

[kernelgpf]

Oh. =P Sorry.

[GingerRobot]

I have 2 different "types" - one is car and the other is caravan

 

How can I make it just "car" is searched for?

 

thanks!

 

To search for just cars:

 

SELECT * FROM `yourtable` WHERE `type`='car'

 

For just caravans:

 

SELECT * FROM `yourtable` WHERE `type`='caravan'

[le007]

Ok thanks goys!

Leo