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
nukeNAV
Home
Content
Downloads
Encyclopedia
FAQ
Feeds
Forums
Sitemap
Stories Archive
Tutorials
Web Links
Your Account
Login
Register
Recent Tutorials
Installing nukeSEO
PHP-Nuke and robots.txt
Tutorials
Feeds
Downloads
nukeSEO Latest Downloads
FAQ
nukeSEO Recent FAQs
News
nukeSEO PHPNuke SEO News
Tutorials
nukeSEO New Tutorials
nukeSEO.com: Forums
Forum FAQ
Search
Usergroups
Profile
Log in to check your private messages
Log in
Searching for complete words
nukeSEO.com Forum Index
->
mSearch
View previous topic
::
View next topic
Author
Message
jakec
webmaster
Joined: Nov 14, 2006
Posts: 23
Posted: Fri Jul 13, 2012 8:57 am
Post subject: Searching for complete words
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 'de
sign
' or '
sign
ificant'.
Thanks in advance
jakec
Back to top
kguske
Site Admin
Joined: May 12, 2005
Posts: 876
Posted: Sat Jul 14, 2012 6:10 pm
Post subject:
Not that I know of.
_________________
Back to top
jakec
Posted: Sun Jul 15, 2012 5:06 am
Post subject:
Would it be an easy mod to return an exact match?
Back to top
kguske
Posted: Sun Jul 15, 2012 8:35 am
Post subject:
Not sure. I've never needed that - what would the SQL look like?
Back to top
jakec
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?
Back to top
jakec
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.
I need to get some sleep and I'll have a look at this again tomorrow.
Back to top
montego
webmaster
Joined: Dec 26, 2005
Posts: 254
Posted: Sat Jul 21, 2012 10:46 am
Post subject:
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
!
Back to top
montego
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
Back to top
Display posts from previous:
All Posts
1 Day
7 Days
2 Weeks
1 Month
3 Months
6 Months
1 Year
Oldest First
Newest First
nukeSEO.com Forum Index
->
mSearch
All times are GMT - 5 Hours
Page
1
of
1
Jump to:
Select a forum
Support
----------------
nukeSEO.com Announcements
nukeSEO (tm)
nukeWYSIWYG (tm)
nukeFEED (tm)
nukeNAV (tm)
nukePIE (tm), nukeREADER (tm)
nukeSLIDER (tm)
nukeSPAM (tm)
mSearch
General
----------------
PHP-Nuke enhancement ideas
Nuke Appreciation
General / Other Stuff
You
cannot
post new topics in this forum
You
cannot
reply to topics in this forum
You
cannot
edit your posts in this forum
You
cannot
delete your posts in this forum
You
cannot
vote in polls in this forum
Powered by
phpBB
© 2001-2008 phpBB Group
Forums ©
PHP-Nuke Copyright © 2004 by Francisco Burzi. This is free software, and you may redistribute it under the
GPL
. PHP-Nuke comes with absolutely no warranty, for details, see the
license
.
Page Generation: 0.03 Seconds