SQL newbie SELECT question

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
cczernia
Forum Newbie
Posts: 20
Joined: Tue May 16, 2006 2:00 pm
Location: San Diego, CA

SQL newbie SELECT question

Post 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.
User avatar
Zoxive
Forum Regular
Posts: 974
Joined: Fri Apr 01, 2005 4:37 pm
Location: Bay City, Michigan

Post by Zoxive »

Code: Select all

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