IKE '%Machico%'
If this works, try deleting and re-inserting the row.
I've had a similar situation in the past.
Hope this helps,
Paul
-Original Message-
From: Wenca [mailto:[EMAIL PROTECTED]
Sent: 27 October 2005 10:56
To: mysql@lists.mysql.com
Subject: Record exists bu
Wenca wrote:
SELECT * FROM tab_p WHERE d_id = 20602 AND name LIKE 'Machico'
-> no results
Try it with ...AND `name` LIKE '%Machico%';
I have encountered it once when there were non printable characters in
front of or after the text itself. Very frustrating!
You can see what extra characters
Hi all,
I've got a problem that I don't understand and that is driving me mad.
I have a table 'tab_p' with this structure:
nametype
---
p_idmediumint(8) AUTOINCREMENT NOT NULL PRIMARY KEY
d_idsmallint(5) NOT NULL
namevarchar(50) NOT NULL
An
