searching an SQL table using keywords

Broadbandplacey · 28 Mar 2007 at 21:54

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 · 28 Mar 2007 at 22:44

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

Broadbandplacey · 28 Mar 2007 at 23:12

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 · 29 Mar 2007 at 00:30

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