Search mysql

[rakuci]

Hi how can a make a search form with the precisely keyword, for example when I search on ING I want only ING to be shown not the rest like jumping or visiting
Thanx is advanced

[Jyotsna]

I think you schould do it like this:

SELECT blablabla FROM table WHERE name = keyword;

Normally you get only the results with the keyword then...

[rakuci]

I made a mistake
because I want to be searched That when you search on ING then he should show the results like ING GROUP ,ING B.V etc but not jumping or searching or GROUP ING
Thanx

[Jyotsna]

SELECT blablabla FROM table WHERE name = "keyword" and name NOT LIKE "ing";

I have no idea if this works, but you can try...