MySQL 'WHERE LIKE'

[emcb_php]

Hi,

Im creating a search engine, which will take keywords in a key+key fashion. Could someone refresh my mind on how i do a select to match a keyword given on the database?

Cheers

[Anon]

select * from table where keywords like '%$searchword%'

will return a match if the $searchword variable exists in the field with anything preceeding or following it.

select * from table where keywords like '$searchword%'

would return a match if the keyword field begins with the $searchword variable and ends with anything.

[van__]

$sql = "SELECT * FROM myTable WHERE myKeyWords RLIKE 'something|else|or+otherwise'";

[emcb_php]

Thank all,

My memory's a bit bad with learning c#.

Elfyn