nightmare sql problem

[jk11uk]

hi

 

ive got a column of keywords and all i want to do is select * where keyword='KEYWORD'. so my query is:

_{SELECT *}

_{FROM  `keywords`}

_{WHERE  `keyword` =  'ppi'}

 

now i have the string 'ppi' in the column, but it wont select it! The annoying thing is i went into phpmyadmin and tried it, no luck. then went into that entry, deleted 'ppi' and replaced with ccc. the search could find 'ccc'! WTF? i then changed back to 'ppi' and it could find that. this happens with every string i have in this column. any ideas?

 

[dreamwest]

You could have spaces in you keyword column _ppi

 

Try:

SELECT *
FROM  `keywords`
WHERE  `keyword` LIKE  'ppi'

[jk11uk]

no i wish . no spaces. LIKE doesnt work either

 

thanks though

[o3d]

try

 

select *
from keywords
where keyword like '%ppi%'

 

if no rows are returned, then try

 

select distinct keyword from keywords 

 

and see what values are available for keyword

[jk11uk]

thank you so much. I've been scratching my head over this (and tearing hair out) for at least 4 hours 

 

the code worked. What do the %'s mean?

[jk11uk]

although the problem now is, say i search for %ppi%, it also returns anything with 'ppi' in - not exact matches (which is what i need). I can use php to sift out the non-exact matches but as this is not efficient do you know what to do? if not i'll go with inefficiency

[kickstart]

Hi

 

The % is a wildcard. It is matching for zero or more characters.

 

Original problem was probably that ppi in the table probably had a leading or trailing space.

 

All the best

 

Keith