Help..... SQL query string problem

[omalic]

Hello all,

 

I am working on a search engine using the above platform however, I have come across a problem that I've failed to resolve. Given a table with infor... I want to do a search such as:

 

"C#", "c++", "word++", "word--", "word&", "@word "word++", "#word", "++word", "&&word" etc

 

on title or description that match the exact word. The SQL statement I am using is given below.

 

SELECT Distinct a.ID, a.Title, a.Description ,a.DateCreated, FROM `table` AS a WHERE ucase(a.Title) REGEXP ucase(@Search) or ucase(description) REGEXP ucase(@Search);

 

These search strings are passed to my storeproc without any issues however, the result produced by the above does not match the search string. Where am I going wrong?

[misheck]

Hi have you tried having variables for the queries described before you use them in the mysql query? I would attempt that first. Can you post a code so I can have a look at it.

[fenway]

Don't post the code -- show us the actual queries.