On 12 Sep 2003 at 8:39, Nelson Azambuja Jr. wrote: > I tried the following: > > SELECT * FROM table WHERE name LIKE '% John %'; > > But it didn't work.
Please explain what didn't work. What were you expecting to happen, and what actually happened? > To explain: I don't want the string 'Johnson' to be shown when > running the query above. It shouldn't be (unless you've found a bug, which is unlikely). Post the exact query you're using and the results you get. You might also want to look into FULLTEXT indexes: http://www.mysql.com/doc/en/Fulltext_Search.html -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]