searching an SQL table using keywords

[Broadbandplacey]

evenin all, hope someone can help me here,

im trying to search a field 'keywords' in a table called 'photos'

now the keywords field will have things like; "Landscape, water, beach, lighthouse" - but i just cant find an SQL query that will work when i search for the term 'landscape' and bring all results with the keyword landscape.

any pointers? cheers

 

[Broadbandplacey]

how do the percentage marks difer from just searching 'landscapes' or is it just the way its done

 

[Broadbandplacey]

thank you muchly that works for what i need

how about searching more than one field? it doesnt seem to work on my description field which is not neat and ordered with comma's but a description about the photo?

SELECT *
FROM `photos`
WHERE `keywords` LIKE '$searchvalue'
AND `description` LIKE '$searchvalue'
ORDER BY `photos`.`ID` DESC
LIMIT 0 , 4

 

[Broadbandplacey]

thanks all,

i've been looking into the full text searching but havent had much look so far, i'll look into creating key word tables, lots and lots to think about

again cheers all