Searching for complete words

webmaster Joined: Nov 14, 2006 Posts: 23

Hi,

Is there a way to search for complete words. For instance if you are searching for 'sign' at the moment it will also return 'design' or 'significant'.

Thanks in advance

jakec

Site Admin Joined: May 12, 2005 Posts: 876

Not that I know of.
_________________

Posted: Sun Jul 15, 2012 5:06 am Post subject:

Would it be an easy mod to return an exact match?

Posted: Sun Jul 15, 2012 8:35 am Post subject:

Not sure. I've never needed that - what would the SQL look like?

Posted: Sun Jul 15, 2012 9:59 am Post subject:

To be honest I'm a bit out of my comfort zone, but is it as simple as changing the 'like' to '=' in function doquery?

Posted: Sun Jul 15, 2012 3:59 pm Post subject:

I guess it isn't that simple, just gave it a go but it didn't work. Sad

I need to get some sleep and I'll have a look at this again tomorrow.

webmaster Joined: Dec 26, 2005 Posts: 254

If you can figure out an appropriate regular expression, it might be possible to use MySQL's regex capabilities:

http://dev.mysql.com/doc/refman/5.0/en/regexp.html
_________________
Only registered users can see links on this board! Get registered or login!
Only registered users can see links on this board! Get registered or login!

Posted: Sat Jul 21, 2012 11:11 am Post subject:

By the way, another option might be to place a FULLTEXT index on the table/columns of interest and then use word searches.

http://dev.mysql.com/doc/refman/5.1/en/fulltext-search.html

Welcome to nukeSEO.com !	Home News Stories Archive Forums Forums Unanswered Posts Modules Content Downloads Encyclopedia FAQ Feeds Tutorials Web Links Your Account Login Register Site Info Sitemap