Posted by brendan on 06/29/05 15:00

um ... could someone tell me why this seemingly obvious statement intented
to bolden returned search terms returns a blank description field?

SELECT
links_DB.type, links_DB.link_ID,
links_DB.hyperlink, links_DB.title, links_DB.starts, links_DB.keywords,
links_DB.contact_person, links_DB.author, links_DB.img_thumb_ID,
keychain.level, keychain.key_ID,
REPLACE(links_DB.description,'$search_term','<b>$search_term</b>'),
MATCH ( title, description, author, contact_person )
AGAINST ( '$search_term' ) AS score


ALSO tried using
REPLACE(links_DB.description,'$search_term','<b>$search_term</b>') AS
description,
this just gave me back the field without the replaced value!
argh
help
ta

• Next in forum: Re: Grouping system
• Prev in forum: Re: truncate table vs delete from table
• Thread view: select replace()

[Reply to this message]