MySQL Performance: MySQL => Making query shorter

Making query shorter [message #542]

Sat, 06 January 2007 19:31

willybnl2
Messages: 6
Registered: December 2006

Junior Member

To search within a database with a lot of text i'm now using

`column` like '%text%'

but this query will also include a lot of words I do not need.
Example:

This is a test
Istesto in abo
Test this phrase

Now when I query it with the above `column` like '%test%' i will get all three... but the 2nd is bogus.

Though i can not do
`column` like '% text%'
including a space, because it would not get the 3rd too...

So the problem is:
How to query using % % (and a third something?) so that it will also get the 3rd result (with the word at the very beginning), but that it will make sure it's a word, not part of the word.

p.s. No I can not use fulltext as the words are to short, this is the backup script if fulltext fails Smile

Report message to a moderator