Mailing List Archive


Back to the month index Back to the list index
Liam Kirsher (liam@numenet.com)
Wed, 02 Apr 1997 18:40:43 -0800 

Message-Id: <3.0.32.19970402183120.00b6ce60@numenet.com>
Date: Wed, 02 Apr 1997 18:40:43 -0800
From: Liam Kirsher <liam@numenet.com>
Subject: [mSQL] Strange mSQL behavior... bug with LIKE functionality?

Hi,

Can anyone help with this? When I perform the following select I get back a record I wouldn't expect, the Devereux name field does not have the string 'ABC' in it.

What gives? The other two I would expect.

Searching for the random string '%a65487987ske83k#%' returns just the Devereux row.

Searching for random string '%c65487987ske83k#%' returns 8 non-matching 'matches'.

The workaround is substituting RLIKE, so I'm not stuck; but I was defninitely surprised by the LIKE behavior!

Thanks for any help!

Liam

----------

mSQL > SELECT pin,name,address,city,state,zip FROM schools WHERE state='CA' AND

name LIKE '%ABC%'\g

Query OK. 3 row(s) modified or retrieved.

 | pin | name | address | city | state | zip |

 

 | 00079117 | DEVEREUX FOUNDATION CALIFORNIA | PO BOX 1079 |

SANTA BARBARA | CA | 931021079 |

 | 00156353 | BABCOCK ELEMENTARY SCHOOL | 2400 CORMORANT WAY |

SACRAMENTO | CA | 958152790 |

 | 04152763 | ABC EDUCATIONAL CENTER | 1129 COLE AVE |

LOS ANGELES | CA | 900381501 |

--<bold><color><param>0000,0000,8080</param>---------------------------------------------------------------------

Liam Kirsher Email: liam@numenet.com

Numenet, Inc. Voice: 415-456-6822

775 E. Blithedale Ave. Suite 176 Fax: 415-456-0599

Mill Valley, CA 94941 URL: http://www.numenet.com

-----------------------------------------------------------------------</color></bold>
--------------------------------------------------------------------------
To remove yourself from the Mini SQL mailing list send a message containing
"unsubscribe" to "unsubscribe" to msql-list-request@bunyip.com. Send a message containing
"info msql-list" to majordomo@bunyip.com for info on monthly archives of
the list. For more help, mail owner-msql-list@bunyip.com NOT the msql-list!