How come this LIKE clause isn't working to search words?

[Jakez]

OK I have a search form on my page, I want to search the database for each word someone types in, for example instead of matching the exact phrase "song lyrics" I want it to search for fields containing "song" AND/OR "lyrics".

 

I tried this query below but no luck:

 

SELECT * FROM table WHERE field LIKE 'song' OR field LIKE 'lyrics' OR other_field LIKE 'song' OR other_field LIKE 'lyrics'

 

What am I doing wrong?

[Ken2k7]

SELECT *
FROM table
WHERE field IN ('song', 'lyrics')
     OR other_field IN ('song', 'lyrics');

[corbin]

SELECT *
FROM table
WHERE field IN ('song', 'lyrics')
     OR other_field IN ('song', 'lyrics');

 

 

 

Uh....  You either didn't read his question or you don't know what IN does.

 

 

 

 

With LIKE you have to use certain symbols.  ? means 1 of any character, and % means any amount of any character...

 

 

So you could do something like:

 

 

SELECT * FROM blah WHERE field LIKE '%someword%';

[Ken2k7]

I assumed the field is either song or lyrics. Perhaps I misunderstood. Sorry.

 

And corbin, ? isn't a LIKE symbol. I think you meant "_" (without quotes).