in reply to Re^2: Escaping quotes - can't quite get it!
in thread Escaping quotes - can't quite get it!

Maybe now is a good time to learn about SQL?

Depending on your SQL dialect, the "one character" (or "one byte", depending on your database/data structure) wildcard is _ or ?. As you seem to be successfully using % as wildcard, it is more likely _ than ?.

Replies are listed 'Best First'.
Re^4: Escaping quotes - can't quite get it!
by ultranerds (Hermit) on May 18, 2011 at 09:08 UTC
    Hi,

    Yup, I keep meaning to purchase a book on mySQL. Maybe I will do that now, to start making use of my new Kindle ;)

    Thanks again - I managed to get it working now.

    Cheers

    Andy