1 More question!! (me think!)

Mantis · March 8th, 2005, 07:14 AM

Hi,
I have almost finish my search page!! which is good!! well for me anyway ;)

Got 1 more query about MySQL (I think)
How do I search for keywords?
I was thinking about:
$query = "SELECT * FROM Table_Article WHERE
Article_Title CONTAIN SearchText OR Article_Main CONTAIN SearchText ";

Which I haven't try to run because I'm pretty sure there's no such CONTAIN (SQL?) comand..

Anyone with the correct command for me??
Thks :)

ChrisScott · March 8th, 2005, 07:22 AM

Hi Mantis,

Try this...

Code:

$query = "SELECT * FROM Table_Article WHERE 
Article_Title LIKE '%SearchText%' OR Article_Main LIKE '%SearchText%';";

(the % are wildcards)

HTH,

Chris

Mantis · March 8th, 2005, 08:26 AM

This is so cool :D
Thks :) :)