Jump to content

Help..... SQL query string problem


omalic

Recommended Posts

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?

Link to comment
https://forums.phpfreaks.com/topic/179092-help-sql-query-string-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.