Page 1 of 1

SQL newbie SELECT question

Posted: Mon Sep 10, 2007 1:10 pm
by cczernia
I have a quick question about SELECT. It seems when I'm trying to SELECT a string it only retrieves items that are an exact match. How do I get it to SELECT a record if it is only has part of string.

Posted: Mon Sep 10, 2007 1:50 pm
by Zoxive

Code: Select all

Select * from `strings` where `string` LIKE '%HE%'
Mysql LIKE