[weilies]

i encounter some prob in using a like clause

let say there are two records in a field:

- "One day, There a dog"
- "its name is sethere"

i want to use a where clause to select the first one but not return the second one, so i wrote something like

"select .... like '% ther%'

a space in front of the keyword "ther" intend to search something meaningful like in other situation, type in "test" hope to search for results like "test", "testing", "tested"... but not "abcdtest" bcoz the result is meaningless.

this sql string work well until encounter something like the keyword "ther" we wana search is the first word like

- "there is ...."

it wont return a result although it matched. i know what's wrong but hav no idea in how to consturct the sql statement...

i hope i make myself clear....

[ben.periton]

If you only want to return test, testing etc but not abatest then use

...LIKE 'test%'.. with % at the end only.

% matches 0 or more chars, _ matches 1 char but can be used multiple times (so ... LIKE 'test___' ... would match testing but not tested as there are 3 underscores _ )

HTH

[NeverMind]

take a look at FULLTEXT search :
http://www.zend.com/zend/tut/tutorial-ferrara1.php