MySQL AND

**phillw** · 10-01-2009, 02:53 AM

I'm no doubt missing something blindingly obvious, but I am puzzled at this behaviour ....

Code:

SELECT * FROM MGJ_Parts WHERE Description LIKE '%oil%'

Returns all the results with oil in the description ....
e.g.

Code:

MGJ Chain Oil (Non Fling)
MGJ Rock Frost (Anti Freeze Air Tool Oil)
MGJ Hydraulic Oil HLP32
..
..

And

Code:

SELECT * FROM MGJ_Parts WHERE Description LIKE '%air%'

Returns ...

Code:

MGJ Rock Frost (Anti Freeze Air Tool Oil)

But ....

Code:

SELECT * FROM MGJ_Parts WHERE Description LIKE ' %air% ' AND Description LIKE '%oil%'

Returns nothing

Phill.

**phillw** · 10-01-2009, 03:09 AM

Ooops ....

My Code was placing spaces around %air% .... Found it - Only an hour of bashing my head against the wall

Phill.

**LiLMsNinja** · 10-01-2009, 12:56 PM

LOL! I just had to say it.. glad to know i'm not the only crazy one that hates, comma's, parenthesis, quotes, spaces, and semi colons.

**phillw** · 10-01-2009, 02:07 PM

Originally Posted by LiLMsNinja

LOL! I just had to say it.. glad to know i'm not the only crazy one that hates, comma's, parenthesis, quotes, spaces, and semi colons.

I think I'll have an MySQL statement to the effect of ....

Code:

mysql> SELECT * from 'life'

On my grave stone ...... Because, if the 'good Lord' doesn't 'get your soul' - those missing semi-colons surely will

Phill.

**phillw** · 10-08-2009, 02:22 PM

bbs - found another bug in the search routine ... ::SIGH::

Thread: MySQL AND