Put a % at the beginning of the string "%Classical%", (which will mean that
any index is not used)
-Original Message-
From: Tyler Longren [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 8 March 2001 4:26 p.m.
To: MySQL List
Subject: Searching for string in field
Hello,
I'
Hello,
I've got a field named genres. It's got a bunch of different music genre's
in it. I want to let a user enter a genre to search for. Here's what I'm
using now:
SELECT * FROM $mysql_artist_table WHERE genres like '$search_genre%' ORDER
BY ARTIST ASC
And that only searches at the beginni
