Hey guys,
I am designing a store in PHP and Postgresql. I've got a long description for my videos that I am going to be selling and would like to be able to search through the description with SQL commands and pick up matching items. Does anyone have any suggestions on how to go about this? Do I just use an explode() function on the white space in the search box and then query where the description is like %keyword% or %keyword2%, etc until I'm done?
Thanks,
Steven