WHERE command OK with number but bad with VARCHAR ?

[hytekk]

HI I have a table to store weblink like this :

linknumber(int), linkadress(VARCHAR),
linkname(VARCHAR), linkcategory(VARCHAR)

Example of data in my table :

1, http://hytekk.com, my first site,test


When I do a search with WHERE apply to a number it's OK, it show my row.

SELECT * FROM mydb WHERE linknumber="1" ( OK STRING )

But when a do a WHERE to linkcategory it did'nt give my any row.

SELECT * FROM mydb WHERE linkcategory="test" ( BAD STRING )


Look like a mismatch of data type ?? I don't know what's wrong

Can someone help ?



Thank you !

[tserbis]

May be
linkcategory LIKE "%test%"
?

[r937]

use the single quote for strings

SELECT * FROM mydb WHERE linkcategory='test'

[hytekk]

I try the command : linkcategory LIKE "%test%"
and that work OK.

But when I need to be more specific with linkcategory = 'test' it didn't show me anything.

I have many row with linkcategory = test, it's that my problem ?

Thank you so much for your help !!!

[r937]

please display a few sample rows which contain the data values you are trying to find

[hytekk]

Here a sample table

linknumber, linkadress, linkname, linkcategory

1, http://hytekk.com, my first site, test
2, http://intrumental.net, my friend site,test
3, http://cj.com, my affiliate site, test
4, http://tenbyten.org, News site, news

It look like this.

thank you !

[Lats]

You may have some extra space(s) in the linkcategory field, try cleaning it up with this...

UPDATE 
	mydb
SET 
	linkcategory = trim(linkcategory)

[hytekk]

I had trim my field but still no result ...
I am still unable to compare direct string statement
Indirect string work ...
When I compare direct number it's work fine .

Maybe it is the table I create ? ( See my first post )
I set linknumber to PRIMARY KEY and that's all ...

We will triumph !

[r937]

do you have phpmyadmin or a similar front end program?

please dump the table structure and a few rows of data so that i may test this for myself