How exactly the LIKE keyword works?

[dmkFoto]

I have a table named Inventory and have 3 items in it containing the work w069.

I want to run a query to return the three items.

My query: Select * from Inventory where Description Like 'w069'

It doesn't seem to work, returning zero row.

What's wrong?

Alex

 

[johnwm]

Using LIKE without a wildcard operator is almost the same as using =

For true LIKE functionality try

Select * from Inventory where Description Like '%w069%'

For more detail see

http://dev.mysql.com/doc/refman/4.1/en/string-comparison-functions.html

___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints

 

[r937]

almost the same? exactly the same

;-)

r937.com | rudy.ca

 

[dmkFoto]

Thanks.
It works great now.

Alex