Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris
 
PerlMonks  

Re: SQLite select or

by erix (Vicar)
on Nov 18, 2013 at 17:50 UTC ( #1063174=note: print w/replies, xml ) Need Help??


in reply to SQLite select or

 OR LOWER($select_1) LIKE '%$Word'"

Looks like you have forgotten the final % at the end of the second LIKE expression.

It should be

 OR LOWER($select_1) LIKE '%$Word%'"

Replies are listed 'Best First'.
Re^2: SQLite select or
by Anonymous Monk on Nov 18, 2013 at 18:58 UTC

    thank you...this was the problem. Shame on me! 2 Hours try to understand what was wrong.

      Q:   Why do programmers have flat heads?
      A:   (whack!) “D‘oh!!!”

      This sort of thing happens to everyone.   More frequently than we usually care to admit.

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1063174]
help
Chatterbox?
[1nickt]: I miss the days when you could customize every aspect of your PC on the Dell site.
[1nickt]: Or, just build one. (Actually I built a gaming PC for my son last year just like in the old days!)
[stevieb]: I remember the days where a consumer was allowed to have independent thought and choice too
[marioroy]: stevieb :)
[marioroy]: that is funny, made me smile. miss those days
[marioroy]: thank you, humor of the day stevieb++

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (6)
As of 2017-03-26 18:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Should Pluto Get Its Planethood Back?



    Results (315 votes). Check out past polls.